Prepare the loan amortization table/schedule from scratch (not the Excel template) for the conventional mortgage presented in Exhibit 8-10 (page 246 7th edition.)

EXHIBIT 8-10 Federal Truth in Lending Disclosure Requirements (FRM Transactions) Conventional $ 614 (a) Prepaid finance charges Loan origination fee Discount fee (points) Prepaid interest 614 59 Prepaid mortgage Insurance -0- Prepaid finance charge $ 1,287 (b) Payment amount Constant $ 329.39 Highest Lowest (c) Number of payments 360 $118.580 58.507 (d) Total of payments (c times b) (e) Total finance charge Amount financed (1) First method Original loan balance Less: 61.360 Prepaid finance charge (1 287) $ 60,073 $118,580 Amount financed (2) Second method: Total payments Less: Total finance charge Amount financed (9) APR $ 58,507 $ 60,073 5.2% EXHIBIT 8-10 Federal Truth in Lending Disclosure Requirements (FRM Transactions) Conventional $ 614 (a) Prepaid finance charges Loan origination fee Discount fee (points) Prepaid interest 614 59 Prepaid mortgage Insurance -0- Prepaid finance charge $ 1,287 (b) Payment amount Constant $ 329.39 Highest Lowest (c) Number of payments 360 $118.580 58.507 (d) Total of payments (c times b) (e) Total finance charge Amount financed (1) First method Original loan balance Less: 61.360 Prepaid finance charge (1 287) $ 60,073 $118,580 Amount financed (2) Second method: Total payments Less: Total finance charge Amount financed (9) APR $ 58,507 $ 60,073 5.2%