Replace the contents of cell A1 with your class number and name. Use a format to...

 

Transcribed Image Text:

Replace the contents of cell A1 with your class number and name. Use a format to show decimals, dollar signs, % and commas consistent with the example figures below. Use the format option with parentheses and red for negative values in the loan amortization table (see cell F11 on the second example below). Show the dollar sign only for appropriate inputs and top of columns. See Asign1 Custom Number Format.docx for the code to replicate dollar formats. Rewrite the Loan Amortization sheet to round the computed payment in B5 to the next highest penny. Use the amount of this payment for all but the last period of the loan. The formula for the last payment should be adjusted to pay off the loan to the nearest penny. Do NOT round any calculations other than those in the payment cells in B5 and column C. As in the examples below, format all dollar values so that pennies are shown only if the amount borrowed is less than one million. Replace the contents of cell A1 with your class number and name. Use a format to show decimals, dollar signs, % and commas consistent with the example figures below. Use the format option with parentheses and red for negative values in the loan amortization table (see cell F11 on the second example below). Show the dollar sign only for appropriate inputs and top of columns. See Asign1 Custom Number Format.docx for the code to replicate dollar formats. Rewrite the Loan Amortization sheet to round the computed payment in B5 to the next highest penny. Use the amount of this payment for all but the last period of the loan. The formula for the last payment should be adjusted to pay off the loan to the nearest penny. Do NOT round any calculations other than those in the payment cells in B5 and column C. As in the examples below, format all dollar values so that pennies are shown only if the amount borrowed is less than one million.

Answer rating: 100% (QA)

Loan Amortization Schedule Loan Details Loan Amount 500000 Interest Rate 5 Loan Term 30 years Paymen... View the full answer