50.1K

Verified Solution

Link Copied!

Requirements 1 Complete the data table. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. 2 using the present value of an ordinary annuity table, calculate the payment amount and complete the amortization schedule. Use the effective interest amortization method. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. a. Calculate the loan payment by dividing the loan amount by the appropriate present value factor. b. Round values to two decimal places. Calculate the interest expense in the third year as the loan payment minus the loan balance at the beginning of the third year. c. Use absolute cell references and relative cell references in formulas. Use absolute cell references C6 and C19 only to calculate interest expense and payment calculations. 3 Using the Excel PMT function, calculate the payment amount and complete the amortization schedule. Use the effective interest amortization method. a. The PMT function calculates a payment amount that results in a negative number. Reverse this to a positive number for calculations in the amesization schedule. b. Round values to two decimal places. Calculate the interest expense in the third year as the loan payment minus the loan balance at the beginning of the third year. Use absolute cell references and relative cell references in formulas. Use absolute cell references C6 and C39 only to calculate interest expense and payment calculations. .N Requirement 1 Complete the data table. Enter all amounts as positive values. Do not use a minus sen or parentheses for any values DATA Loan Amount Interest Rate Periods Requirement 2 Using the present value of an ordinary annulty table, calculate the payment amount and complete the amortization schedule Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. Use the effective interest amortization method. (Aways use cell references and formulas where appropriate to receive full credit. you copy/paste from the instructions tab, you will be marked wrong) Calculate the loan payment by dividing the loan amount by the appropriate present value factor. b. Round values to two decimal places Calculate the interest expense in the third year as the loan payment minus the loan balance at the beginning of the third year. Use absolute cell references and relative cell references in formulas. Use absolute cell references only to cells C6 and C19 for interest expense and payment calculations. C. Payment (using PV table Present Value of an Ordinary Annuity oE1 Principal Beginning Interest Ending Balance Total Payment Perlod 6% 10% Balance Payment Epense 09434 18334 2.6730 0.9259 1.7833 0.9091 17355 1. 2.5771 33121 24869 1.1699 4. 3.4651 1.7908 42124 3.9927 Total Requirement Using the Excel PMT function, calculate the payment amount and complete the amortiration schedule Use the effective interest amortization method. (Always use cell references and formulas where appropriate to recelve full credit. f you copy/paste from the instructions tab, you will be marked wrong) The PMT function calulates a pyment amount that results in a negative number Reverse this to a positive number for calculations in the amortiration schedule Round valum to two decimal plaes Calculate the interest expense in the third year as the loan payment minus the loan balance at the beginning of the third year Use absolute cell references and relative cel references in formulas. Use absolute cell references only to cells C6 and C39 for interest epense and payment calculations b. Payment (using PMT function) Ending Interest Beginning Balance Principal Total Payment Period Balance Expense Payment Total Requirements 1 Complete the data table. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. 2 using the present value of an ordinary annuity table, calculate the payment amount and complete the amortization schedule. Use the effective interest amortization method. Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. a. Calculate the loan payment by dividing the loan amount by the appropriate present value factor. b. Round values to two decimal places. Calculate the interest expense in the third year as the loan payment minus the loan balance at the beginning of the third year. c. Use absolute cell references and relative cell references in formulas. Use absolute cell references C6 and C19 only to calculate interest expense and payment calculations. 3 Using the Excel PMT function, calculate the payment amount and complete the amortization schedule. Use the effective interest amortization method. a. The PMT function calculates a payment amount that results in a negative number. Reverse this to a positive number for calculations in the amesization schedule. b. Round values to two decimal places. Calculate the interest expense in the third year as the loan payment minus the loan balance at the beginning of the third year. Use absolute cell references and relative cell references in formulas. Use absolute cell references C6 and C39 only to calculate interest expense and payment calculations. .N Requirement 1 Complete the data table. Enter all amounts as positive values. Do not use a minus sen or parentheses for any values DATA Loan Amount Interest Rate Periods Requirement 2 Using the present value of an ordinary annulty table, calculate the payment amount and complete the amortization schedule Enter all amounts as positive values. Do not use a minus sign or parentheses for any values. Use the effective interest amortization method. (Aways use cell references and formulas where appropriate to receive full credit. you copy/paste from the instructions tab, you will be marked wrong) Calculate the loan payment by dividing the loan amount by the appropriate present value factor. b. Round values to two decimal places Calculate the interest expense in the third year as the loan payment minus the loan balance at the beginning of the third year. Use absolute cell references and relative cell references in formulas. Use absolute cell references only to cells C6 and C19 for interest expense and payment calculations. C. Payment (using PV table Present Value of an Ordinary Annuity oE1 Principal Beginning Interest Ending Balance Total Payment Perlod 6% 10% Balance Payment Epense 09434 18334 2.6730 0.9259 1.7833 0.9091 17355 1. 2.5771 33121 24869 1.1699 4. 3.4651 1.7908 42124 3.9927 Total Requirement Using the Excel PMT function, calculate the payment amount and complete the amortiration schedule Use the effective interest amortization method. (Always use cell references and formulas where appropriate to recelve full credit. f you copy/paste from the instructions tab, you will be marked wrong) The PMT function calulates a pyment amount that results in a negative number Reverse this to a positive number for calculations in the amortiration schedule Round valum to two decimal plaes Calculate the interest expense in the third year as the loan payment minus the loan balance at the beginning of the third year Use absolute cell references and relative cel references in formulas. Use absolute cell references only to cells C6 and C39 for interest epense and payment calculations b. Payment (using PMT function) Ending Interest Beginning Balance Principal Total Payment Period Balance Expense Payment Total

Answer & Explanation Solved by verified expert

See Answer