make a data input and output area where the working formulas will be. formulas required

D Comprehensive/Spreadsheet Problem m Vala Maaray A WWW Ter Aw - Trai W IN We ARTITI A B D E F 8 a. Assuming a rate of 109 annually, find the FV of $1,000 after 5 years. 9 10 11 12 b. What is the investment's FV at rates of 0%, 59, and 20% after 0, 1, 2, 3, 4, and 5 years? 13 14 15 1 c. Find the PV of $1,000 due in 5 years if the discount rate is 10% d. What is the rate of return on a security that costs $1.000 and returns $2,000 after 5 years? 16 17 18 19 20 21 22 23 24 25 26 27 e. Suppose California's population is 36.5 million people and its population is expected to grow by 2% annually. How long will it take for the population to double? f. Find the PV of an ordinary annuity that pays $1,000 each of the next 5 years if the interest rate is 15%. What is the annuity's FV? g. How will the PV and FV of the annuity in part f change if it is an annuity due? h. What will the FV and the PV be for $1,000 due in 5 years if the interest rate is 1096, semiannual compounding? 29 30 L. What will the annual payments be for an ordinary annuity for 10 years with a PV of $1,000 If the interest rate is 896? What will the payments be if this is an annuity due? 31 32 3. Find the PV and the FV of an investment that pays 8% annually and makes the following end-of-year payments: 33 24 Sheet1 0 1 2 3 3 $100 $200 $400 1. Suppose you borrow $15,000. The loan's annual interest rate is 8%, and it requires four equal end-of-year payments. Set up an amortization schedule that shows the annual payments, interest payments, principal repayments, and beginning and ending loan balances. M N eiswer questions through and I. USING EXCEL you have to have to create (1) a formula using the formula from the book and use the "huilt in function in EXCEL I will demonstrate with question the problems are a picture so you can pull it down as you go to the next problem. Also tell me why the formula gives a potem wes and the built in function was negative ou only need to answer this question once Input area Rate 10% Nper 5 Pint N/A PV $1,000 Type N/A answer $1,610.5100 $1,610,51001