Clipboard 851 B D E Format the entries in each Calculation 1 [5-year savings) Calculation #2 (10-year savings) Calculation #3 (15-year savings) row as... 5 complete this table for your 5-year, 10-year, and 15-year 37 savings Contribution amount (P) (Bring forward your Monthly Savings amount, using a 38 formula, for each entry) ...Currency with 2 decimal places APR from the table in 0.3% 0.3% 0.3% 39 40 Number of contributions per year() Number of years (t) 41 Total amount saved (A): 42 ...a Number with o decimal places a Number with decimal places ...Currency with 2 decimal places ...Currency with 2 decimal places ...Currency with 2 decimal places Total contributions: 43 Total accrued interest: 44 45 45 47 Loan 6 Calculation 1 (5-year loan) Calculation 2 (10-year loan) Calculation 3 (15-year loan) Format the entries in each TOW a... Continue by completing this table for your 5-year, 10 year, and 15 year loans, based on the principal and interest rates 40 given with monthly payments Loan principal (P) 40 ADR from the table (t), with a slightly higher rate for longer loans Humber of contributions per 50 $15,000.00 $15,000.00 $15,000,00 7.3% 9.2% 11.36 a Number with o decimal 7.3% 9.3% 11.3% 50 APR from the table (r), with a slightly higher rate for longer loans Number of contributions per yearin) Number of years (1) 51 52 53 Payment amount (PMT): Total amount paid over the time 54 of the loan: .a Number with o decimal places ...a Number with o decimal places ...Currency with 2 decimal places Currency with 2 decimal places Currency with 2 decimal Total amount of interest paid: 55 56 57 places 58 Comparison After 5 years After 10 years 7 Use Excel formulas to transfer your amounts from above Total savings from energy improvements After 15 years Format the entries in each row as.... 50 Total loan payments 61 Currency with 2 decimal places ...Currency with 2 decimal places 62 Have you broken even at this point yes or no 2 64 06 70 72 Grading Sheet Savings and Loan Analysis Budget Cost Projection Conversions Clipboard 851 B D E Format the entries in each Calculation 1 [5-year savings) Calculation #2 (10-year savings) Calculation #3 (15-year savings) row as... 5 complete this table for your 5-year, 10-year, and 15-year 37 savings Contribution amount (P) (Bring forward your Monthly Savings amount, using a 38 formula, for each entry) ...Currency with 2 decimal places APR from the table in 0.3% 0.3% 0.3% 39 40 Number of contributions per year() Number of years (t) 41 Total amount saved (A): 42 ...a Number with o decimal places a Number with decimal places ...Currency with 2 decimal places ...Currency with 2 decimal places ...Currency with 2 decimal places Total contributions: 43 Total accrued interest: 44 45 45 47 Loan 6 Calculation 1 (5-year loan) Calculation 2 (10-year loan) Calculation 3 (15-year loan) Format the entries in each TOW a... Continue by completing this table for your 5-year, 10 year, and 15 year loans, based on the principal and interest rates 40 given with monthly payments Loan principal (P) 40 ADR from the table (t), with a slightly higher rate for longer loans Humber of contributions per 50 $15,000.00 $15,000.00 $15,000,00 7.3% 9.2% 11.36 a Number with o decimal 7.3% 9.3% 11.3% 50 APR from the table (r), with a slightly higher rate for longer loans Number of contributions per yearin) Number of years (1) 51 52 53 Payment amount (PMT): Total amount paid over the time 54 of the loan: .a Number with o decimal places ...a Number with o decimal places ...Currency with 2 decimal places Currency with 2 decimal places Currency with 2 decimal Total amount of interest paid: 55 56 57 places 58 Comparison After 5 years After 10 years 7 Use Excel formulas to transfer your amounts from above Total savings from energy improvements After 15 years Format the entries in each row as.... 50 Total loan payments 61 Currency with 2 decimal places ...Currency with 2 decimal places 62 Have you broken even at this point yes or no 2 64 06 70 72 Grading Sheet Savings and Loan Analysis Budget Cost Projection Conversions
