Ensure that the Facilities worksheet is active Enter a reference to the beginning loan balance in cell B12 and enter a reference to the payment amount in cell C12 Enter a function in cell D12, based on the payment and loan details, that calculates the amount of interest paid on the first payment Be sure to use the appropriate absolute, relative, or mixed cell references Enter a function in cell E12 , based on the payment and loan details, that calculates the amount of principal paid on the first payment Be sure to use the appropriate absolute, relative, or mixed cell references Enter a formula in cell F12 to calculate the remaining balance after the current payment The remaining balance is calculated by subtracting the principal payment from the balance in column B Enter a function in cell G12 , based on the payment and loan details, that calculates the amount of cumulative interest paid on the first payment Be sure to use the appropriate absolute, relative, or mixed cell references Enter a function in cell H12, based on the payment and loan details, that calculates the amount of cumulative principal paid on the first payment Be sure to use the appropriate absolute, relative, or mixed cell references Enter a reference to the remaining balance of payment 1 in c ell B13 Use the fill handle to copy the functions created in the prior steps down to complete the amortization table Need help on how to set up these functions in excel s Cut Copy Format Painter AutoSum A Fill Clear Sort Find Filter Select Paste u Merge Center s , Conditional Format as Cell Insert Delete Format 1 Fomatting Table Styles Clipboard Font Alignment Cells Editing A1 Facility Amortization Table Payment Details Loan Details $6,245 45 5 75 6 Payment 7 APR 8 Years 9 Pmts per Year 10 $325,000 00 0 479 Periodic Rate of Payments 12 PaymentBeginning Payment Number PrincipalRemaining Cumulative Cumulative epayment Balance Balance AmountInterest PaidR Principal 12 13 15 18 20 21 10 Insurance Facilities Sales Inventory Ready 100

The Answer is in the image, click to view ...

Question: Ensure that the Facilities worksheet is active . Enter a reference to the beginning loan balance in cell B12 and enter a reference to the

Ensure that the Facilities worksheet is active. Enter a reference to

Ensure that the Facilities worksheet is active. Enter a reference to the beginning loan balance in cell B12 and enter a reference to the payment amount in cell C12.
Enter a function in cell D12, based on the payment and loan details, that calculates the amount of interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Enter a function in cell E12, based on the payment and loan details, that calculates the amount of principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Enter a formula in cell F12 to calculate the remaining balance after the current payment. The remaining balance is calculated by subtracting the principal payment from the balance in column B.
Enter a function in cell G12, based on the payment and loan details, that calculates the amount of cumulative interest paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Enter a function in cell H12, based on the payment and loan details, that calculates the amount of cumulative principal paid on the first payment. Be sure to use the appropriate absolute, relative, or mixed cell references.
Enter a reference to the remaining balance of payment 1 in cell B13. Use the fill handle to copy the functions created in the prior steps down to complete the amortization table.

Need help on how to set up these functions in excel.

s Cut Copy Format Painter AutoSum A Fill Clear Sort & Find & Filter Select Paste u . .:.: Merge & Center s-% , Conditional Format as Cell Insert Delete Format 1 Fomatting Table Styles Clipboard Font Alignment Cells Editing A1 Facility Amortization Table Payment Details Loan Details $6,245.45 5.75% 6 Payment 7 APR 8 Years 9 Pmts per Year 10 $325,000.00 0.479% Periodic Rate # of Payments 12 PaymentBeginning Payment Number PrincipalRemaining Cumulative Cumulative epayment Balance Balance AmountInterest PaidR Principal 12 13 15 18 20 21 10 Insurance Facilities Sales Inventory Ready + 100

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!

Exp19_Excel _AppCapstone_ Compassessment_ Manufacturing Project. please answer questions 11-14 12 Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7...

Exp19_Excel _AppCapstone_ Compassessment_ Manufacturing Project. please answer questions 15-18 12 Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7...

12e Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6. 54 Good B7 = .0325 B8 = 5 E6 = 275000 Most Likely B7 = .057 B8 = 5. E6 =...

I need help with questions 12-20 please. The first portion is here:...

Ensure that the Facilities worksheet is active. Enter a reference to the beginning loan balance in cell B12 and enter a reference to the payment amount in cell C12. 13 Enter a function in cell D12,...

Exp19_Excel _AppCapstone_ Compassessment_ Manufacturing Project. please answer questions 12-15 12 Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7...

1 3 Ensure that the Facilities worksheet is active. Enter a reference to the beginning loan balance in cell B 1 2 and enter a reference to the payment amount in cell C 1 2 . 1 4 Enter a function in...

1. Ensure that the Facilities worksheet is active. Enter a reference to the beginning loan balance in cell B12 and enter a reference to the payment amount in cell C12 . 2. Enter a function in cell...

12) Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, B8, and E6. Good B7 = .0325 B8 = 5 E6 = 275000 Most Likely B7 = .057 B8 = 5 E6 = 312227.32...

Create the following three scenarios using Scenario Manager. The scenarios should change the cells B7, BB, and E6. Good B7_0325 B8 15 E6 275000 Most Likely B7 = .057 B8 = 5 E6 312227.32 Bad B7 =...

In the city of Metropolis, there are 100 residents, each of whom lives until age 75. Residents of Metropolis have the following incomes over their lifetime: Through age 14, they earn nothing. From...

If 7x 2 (2p 2 8)x + 16 = 0 has two roots which are equal in magnitude but opposite in sign then find p.

Who pays FUTA, and what is the current rate and computational structure?

All of the following are advantages of personal interview, except: Group of answer choices opportunity for feedback interviewer influence high participation rate probing complex answers

=+d. Is the headline type broken in phrases, for easier comprehension?

=+c. Does the visual support the headline? Do they work as a single, conceptual unit?

=+b. Does the layout guide the reader to the most important points first (referred to as visual hierarchy)?