Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need all formulas please Now Hwan is ready to calculate the annual principal and interest payments for the expansion loan. Start by calculating the cumulative
need all formulas please
Now Hwan is ready to calculate the annual principal and interest payments for the expansion loan. Start by calculating the cumulative interest payments as follows: . In cell B16, enter a formula using the CUMIPMT function to calculate the cumulative interest paid on the loan for Year 1 (payment 1 in cell B14 through payment 12 in cell B15). Use 0 as the type argument in your formula because payments are made at the end of the period. . Use absolute references for the rate, nper, and pv arguments, which are listed in the range C4:C10. . Use relative references for the start and end arguments. 1. Fill the range C16:K16 with the formula in cell B16 to calculate the interest paid in Years 2-10 and the total interest. 5. Calculate the cumulative principal payments as follows: . In cell B17, enter a formula using the CUMPRINC function to calculate the cumulative principal paid for Year 1 (payment 1 in cell B14 through payment 12 in cell B15). Use O as the type argument in your formula because payments are made at the end of the period. . Use absolute references for the rate, nper, and pv arguments, which are listed in the range C4:10. . Use relative references for the start and end arguments. 1. Fill the range C17:K17 with the formula in cell B17 to calculate the principal paid in Years 2-10 and the total principal. F 6 H IN & I Expansion Loan 1 2 3 Loan Conditions Amounts Depreciation Conditions 4 Loan amount pu) 1800,000 Long-term assets com 1800.000 5 Annual interest rate 4 45% Salvage value salvage) 128,000 6 Monthly interest me brace) 0.37% Life of assettel 10 7 Loan periodin yems 10 8 Loan period in months Inper) 120 9 Monthly payment 118.272) 0 Start date of loan 16/2022 11 12 Annual Principal and Cumulative Interest Payitahts 13 Years 1 2 3 4 5 6 7 8 9 10 14 13 25 37 49 Months 61 73 85 97 109 15 12 24 38 48 60 72 84 36 108 120 Interer 17 Principal 18 Principal remaining 1800,000 1800,000 1800,000 1800,000 1800.000 1800.000 1800.000 1800.000 4800.000 $800,000 19 Remaining 100% 100% 100% 100% 100% 100% 100% 100%. 100% 100% 20 21 Sualcht-Line Depreciation 22 Years 2 3 4 5 6 8 9 10 23 Annual depreciation 24 Cumulative depreciation 10 10 10 10 10 10 10 10 10 10 25 preciated asset value $800,000 1800,000 1800.000 1800,000 1800.000 1800.000 1800.000 $800.000 $800,000 $800,000 26 Monthly Sales Employees Expansion Loan Investments & Projections Read ra Total 10 10 w HI Type here to search oc 62 Step 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