I need help solving part a and b in excel

Hi, This is for a Master's in Finance Fixed Income Course. This assignment given is for me to calculate the price, duration, and convexity of a pass-through security at two different PSA levels. I think it's pretty straight forward in that all the formulas are there, and there's a sample excel with all the information. I will attach the question's pdf, the class room example, and my own attempt at the assignment. My main issue is trying to put the very long formula given for calculating the r(O, T) into excel to get the proper yield rate. Please help me take a look at this. It's due in 15 minutes, but I still want to see what I can do even if I submit late. Thank you....

Looking for help completing the CFA FOUNDATION exam which is online. It is only the foundation level exam, approximately 2 hours, I have all the materials available for you to use....

The Fmva course is financial and accounting course you can search about and you can get all details info of this course from their website “ CFI “ certificate financial institutions, its has lessons and the end of the lesson there’s final exam...

What: submit a three-page buy/sell recommend regarding Nike. This report is to be supported by a valuation of the firm (DCF model and company forecasts) which you have completed in the forecast modeling spreadsheet.Specifics of report: Submit a three-page report that focuses on your recommendations and assumptions regarding Amazon. Your report must state a buy/sell recommendation-you recommend to buy/sell or hold the stock. Base your recommendation upon the closing price of Nike on 9/27/2021. Your report should support your recommendation. Please keep in mind that the report is only three pages so please keep your supporting arguments brief and succinct. Your valuation should be a key component of your support for your recommendation. A recommended breakdown between assumptions and recommendations is two pages devoted to your assumptions and one page devoted to your recommendations.Specifics of spreadsheet: You are to use the pre project 1 spreadsheet that we have done in class as a template. You should download four years of historic financial data for Nike. You must include the income statement, balance sheet and statement of cash flows. Once you have downloaded the Nike data, yo...