Excel 2013 Assignment 4
ehstudent
loan.xlsxDocumentation
| Stewart Financial | |
| Author | |
| Date | |
| Purpose | To calculate the monthly payment and total cost of a mortgage under different conditions |
&D
&F Page &P &A
Loan Analysis
| Stewart Financial | |||||||||
| Loan Table | Cost of the Loan | ||||||||
| Loan Amount (PV) | Interest Rate | Monthly Payment | Total Payments | Cost of the Loan | Years | ||||
| Annual Interest Rate | |||||||||
| Payments per Year | |||||||||
| Interest Rate per Period (RATE) | |||||||||
| Years | |||||||||
| Number of Payments (NPER) | |||||||||
| Monthly Payment (PMT) | |||||||||
| Total Payments | |||||||||
| Cost of the Loan | |||||||||
&D
&F Page &P &A
