Question: How do I make a loan amortization table on Excel ? (a) Prepaid finance charges Loan origination fee Discount fee (points) Prepaid interest Prepaid mortgage
How do I make a loan amortization table on Excel ?
(a) Prepaid finance charges Loan origination fee Discount fee (points) Prepaid interest Prepaid mortgage insurance Prepaid finance charge (b) Payment amount Constant Highest Lowest (c) Number of payments (0') Total of payments (c times b) (e) Total finance charge" (1') Amount financed (1) First method: Original loan balance Less: Prepaid finance charge Amount financed (2) Second method: Total payments Less: Total finance charge Amount financed (9) APR Conventional 5 614 614 109 _-0- 5 1,337 5 504.79 360 $181,724 121,701 61,360 (1,337) 5 60:0231 $181,724 m 5 60,023 9.5% Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
