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 ?

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!