Create a loan amortization table using excel

Conventional Conventional Insured $ 614 614 109 -0- $ 1,337 $ 729 729 133 583 $ 2,174 $ 504.79 360 (a) Prepaid finance charges Loan origination fee Discount fee (points) Prepaid interest Prepaid mortgage insurance Prepaid finance charge (b) Payment amount Constant Highest Lowest ( ) Number of payments (d) 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 N/A $ 633.94 $ 612.69 360 $223,919 153,228 $181,724 121,701 61,360 72,865 (1,337) $ 60,023 (2,174) $ 70,6911 $181,724 $223,919 $121,701 $ 60,023 9.5% 153,228 $ 70,691 10.19% Conventional Conventional Insured $ 614 614 109 -0- $ 1,337 $ 729 729 133 583 $ 2,174 $ 504.79 360 (a) Prepaid finance charges Loan origination fee Discount fee (points) Prepaid interest Prepaid mortgage insurance Prepaid finance charge (b) Payment amount Constant Highest Lowest ( ) Number of payments (d) 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 N/A $ 633.94 $ 612.69 360 $223,919 153,228 $181,724 121,701 61,360 72,865 (1,337) $ 60,023 (2,174) $ 70,6911 $181,724 $223,919 $121,701 $ 60,023 9.5% 153,228 $ 70,691 10.19%