X AutoSave @ Off MA3 Excel Template 20210930 (1) Search (Alt+Q) Doris Ellison DE X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Comments Share Calibri 11 ~A A ab General Insert APO Conditional Format as Delete Paste $ ~ % " Cell Sort & Find & Analyze Formatting Table Styles v Format Filter * Select v Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Insert Pie or Doughnut Chart ~ A20 1 X v fx 5 Now, perform each of the calculations indicated. Please refer to the financial formulas section of the instructions for Major Assignment 3, where you will find the equations for A B D G H 20 21 5 Now, perform each of the calculations indicated. Please refer to the financial formulas section of the instructions for Major Assignment 3, where you will find the equations for 22 the Compound Interest Formula, Future Value of Periodic Payments Formula, and Loan Payment Formula to use for the final calculation in the Sponsorship, Fundraising, and Loan 23 Payment sections below, respectively. Important Note: for these calculations, you MUST use direct calculation formulas, and you MAY NOT use built-in Excel functions to calculate 24 these values. 25 26 Format all amounts (in the gold-shaded cells) as Currency with the $ symbol and 2 decimal places, and all n and t entries (in the green-shaded cells) as Number with 0 decimals. 27 Bring your 5-year projected budget total forward from the Project Budget $3,591,901.95 28 and Projection sheet 20 6 Sponsorship (invest a fixed amount for 5 years with 8 Loan Payment (determine the monthly payment annual compounding) required for a 5-year loan to cover the remainder of the 30 budget costs) The additional amount you need to 21.2% 31 Percentage of your Budget Total to invest cover your 5-year budget costs (P) Principal amount to invest (P), based Excel Grading Sheet Project Budget and Projection Funding + Ready Accessibility: Investigate + 100% 45 F a 7:15 AM Clear 10/11/2022X AutoSave Off MA3 Excel Template 20210930 (1) Search (Alt+Q) Doris Ellison DE X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Comments Share Calibri 14 ~ A" A ab General Insert Ap O Delete Paste B $ ~ % " Conditional Format as Cell Sort & Find & Analyze Formatting Table v Styles ~ Format Filter ~ Select v Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Insert Pie or Doughnut Chart ~ A30 vix fx 6 Sponsorship (invest a fixed amount for 5 years with annual compounding) A B D F G H 20 Copy Cells Fill Series 6 Sponsorship (invest a fixed amount for 5 years with 8 Loan Payment (determine the monthly payment Fill Formatting Only annual compounding) required for a 5-year loan to cover the remainder of the Fill Without Formatting 30 budget costs) Fill Days The additional amount you need to Percentage of your Budget Total to invest 21.2% 31 Fill Weekdays cover your 5-year budget costs (P) Principal amount to invest (P), based on your budget total and the $762,919.97 Fill Months Your APR (r) 7.6% 32 percentage in B31 Fill Years Your APR (r) 8.8% 33 Linear Trend Number of payments per year (n) 12 34 Number of compoundings per year (n) 12 Growth Trend Number of years (t) 5 35 Number of years (t) 5 Flash Fill punt for 5 years with annual compounding) _ 36 Your 5-year sponsorship total $1,180,345.16 Series... 37 38 7 Fundraising (invest monthly donations for 5 years Lonand Excel Grading Sheet Project Budget and Projection Funding + Drag outside selection and release to see fill options; drag inside to clear + 100% 45 F W 7:17 AM Clear a 10/11/2022X AutoSave @ Off MA3 Excel Template 20210930 (1) Search (Alt+Q) Doris Ellison DE X File Home Insert Draw Page Layout Formulas Data Review View Help Acrobat Comments Share Insert Calibri 14 ~ A" A" ab General Ap O Paste B $ ~ % " Conditional Format as Cell Delete Sort & Find & Analyze Formatting Table ~ Styles ~ Format Filter ~ Select v Data Undo Clipboard Font Alignment Number Styles Cells Editing Analysis Insert Pie or Doughnut Chart ~ A39 vix fx 7 Fundraising (invest monthly donations for 5 years with monthly compounding) A B D E F G H 36 Your 5-year sponsorship total $1,180,345.16 37 38 7 Fundraising (invest monthly donations for 5 years Legend 39 with monthly compounding) 40 Monthly contribution amount (PMT) $23,946.01 If a cell is shaded You should Your APR (r) 9.8% Blue Enter a text response 41 Number of compoundings per year (n) 12 Green Enter a number 42 43 Number of years (t) 5 Gold Enter an Excel formula Your 5-year fundraising total (Hint: use the "future value of periodic = Any other color Make no changes payments" formula in the assignments 44 instructions) 45 46 Excel Grading Sheet Project Budget and Projection Funding + Ready Accessibility: Investigate Average: 5990.777775 Count: 11 Sum: 23963.1111 + 100% 45 F 7:19 AM a Clear 10/11/2022