Answered step by step
Verified Expert Solution
Question
1 Approved Answer
What formula do I use for each calculation? Problem 1 (30%) Reproduce Figure A.4, using your favorite spreadsheet software (e.g., Microsoft Excel or Google Sheets).
What formula do I use for each calculation?
Problem 1 (30%) Reproduce Figure A.4, using your favorite spreadsheet software (e.g., Microsoft Excel or Google Sheets). You need to complete the missing rows (Year 3 through 8). Here is a tutorial on relative and absolute cell references: https://edu.gcfglobal.org/en/excelformulas/ relative-and-absolute-cell-references/1/. Submit a screenshot of the spreadsheet only. Formatting can vary. An example (using Google Sheets) is shown below. fx-103052 c D G H 1 K 1 2 3 4 5 Loan Principal ($) Interest Loan term yrs) CRF (n) pery Payments (Slyr) Tax bracket 1000 0.06 10 0.1358679582 135.8679582 0.305 Energy Savings (kWh/yr) Price att = 0 (5/kWh) Savings att - 0 (5/8) Escalating at yr) 1500 0.1 150 5 Personal discount rate Uyr) 0.1 7 8 End of Year 9 0 1 2 Loan Payment Interest Delta Principal Loan Balance Tax Savings 0 0 1000 0 135.8679582 60 75.86795822 924.1320418 135.8679582 55.44792251 80.42003671 843.7120061 16.91161636 Loen Cost Electric Savings Net Savings PV Saving Cum PV Savs 0 0 0 0 0 117.5679582 157.5 39.93204178 36.30185616 36.30185616 118.9563419 165.375 46.41865814 38.36252739 74.66438356 10 11 12 13 14 15 16 17 1a 9 135 8879582 135.8679582 14 94595909 7.690639145 120.9219991 128.1773191 128.1773191 0 4.558517523 2.345644939 131.3094407 133.5223133 232.6992324 244.334194 101.3897917 110.8118807 42 99916919 42.72277701 389.7540722 412.4768492 19 10Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started