Question: Hey I really need help on this. I provided some numbers but I'm very confused on the rest. You're the best:) Trace Depende Insert AutoSum

Hey I really need help on this. I provided some numbers but I'm very confused on the rest. You're the best:)

Hey I really need help on this. I provided some
Trace Depende Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Create from Selection Function Used Time Reference Trig Functions Remove Arrows 117 X fx B C D E 20 21 5 Now, perform each of the calculations indicated. Refer to the Financial formulas section provided on the Instructions word document as needed. 22 23 Format all amounts as Currency with the $ symbol and 2 decimal places, and all n and t entries as Number with 0 decimals. 25 Bring your 5-year projected budget total forward from the Project Budget S 341,400.00 26 and Projection sheet 27 6 Sponsorship (invest a fixed amount for 5 years with annual 8 Loan payment (determine the monthly payment required fo 28 compounding) 5-year loan to cover the remainder of the budget costs Percentage of your Budget Total to invest 25.1% The additional amount you need to cover your 5- 29 year budget costs (P) Principal amount to invest (P), based on your Your APR (r) 3.9% budget total and the percentage above. 85691.4 30 Your APR (r) 4.9% Number of payments per year (n) 31 32 Number of compoundings per year (n) Number of years (t) 33 Number of years (t) The monthly loan payment (PMT) 34 Your 5-year sponsorship total 35 36 7 Fundraising (invest monthly donations for years with Legend 37 monthly compounding $2,276.00 You should 38 Monthly contribution amount (PMT) If a cell is shaded 18.8% Blue Enter a text response 39 Your APR (r) 40 Number of compoundings per year (n) Green Enter a number 41 Number of years (t) Gold Enter an Excel formula Your 5-year fundraising total (Hint: use the "future value of periodic payments" formula in the assignments Any other color Make no changes 42 instructions) Excel Grading Sheet Project Budget and Projection Funding + Ready NOV 9 8 stv

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!