Part 2: Partially amortized fixed rate mortgage (CPM) Im not sure how to set this up in excel, if you could show the ste
Posted: Tue Apr 26, 2022 10:49 am
Part 2: Partially amortized fixed rate mortgage (CPM)
Im not sure how to set this up in excel, if you could show the
steps i would greatly appreciate it! Thank you!
Part 2-Partially Amortized Fixed Rate Mortgage Month Beginning Interest Principal Payment Balance Mortgage Balance House Value Equity 1200000 165.33 1 2 3 4 4 5 6 7 7 Input Box: Initial Mortgage Amount Initial Loan-to-Value Interest Rate Additional Mothly Payment Holding Period Expected Annual Appreciation Rate Amortization $300,000 ?? 4.25% 590.33 77 ?? 40% 8 9 10 11 12 13 Output Box: Monthly Payment Original House Value Mortgage Balance at End of Holding Period Equity at End of Holding Period 77 ?? ?? ?? 14 15 16 17 18 INTEREST RATE LOAN AMOUNT PERIOD MONTNHLY PAYMENTS 0.35% 120000 360 -$590.33 19 20 21 22 23
- Part 2 Partially Amortized Fixed Rate Mortgage Cpm Im Not Sure How To Set This Up In Excel If You Could Show The Ste 1 (77.06 KiB) Viewed 60 times
steps i would greatly appreciate it! Thank you!
Part 2-Partially Amortized Fixed Rate Mortgage Month Beginning Interest Principal Payment Balance Mortgage Balance House Value Equity 1200000 165.33 1 2 3 4 4 5 6 7 7 Input Box: Initial Mortgage Amount Initial Loan-to-Value Interest Rate Additional Mothly Payment Holding Period Expected Annual Appreciation Rate Amortization $300,000 ?? 4.25% 590.33 77 ?? 40% 8 9 10 11 12 13 Output Box: Monthly Payment Original House Value Mortgage Balance at End of Holding Period Equity at End of Holding Period 77 ?? ?? ?? 14 15 16 17 18 INTEREST RATE LOAN AMOUNT PERIOD MONTNHLY PAYMENTS 0.35% 120000 360 -$590.33 19 20 21 22 23