On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references.

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references. Copy the formula to the range C10:C15

On the Attendance worksheet, in cell L5, enter an IF function to determine if the percentage in cell K5 is greater than or equal to the goal in cell H18. The function should return the text Goal Met if true and Review if false. Set the reference to cell H18 as an absolute reference. Copy the formula from cell L5 to the range L6:L11 .

Solutions

Expert Solution

Question 1

Step 1

Click on Cell C9

Step 2

Enter the following formula

=PMT($B$5/12,$B$6,-B9)

Step 3

Enter

Step 4

Now use the fill handle to copy the formula C10:C15

---

Quesiton 2

Step 1

Go to cell L5

Step 2

Enter the following formula

=IF(K5>=$H$18,"Goal Met","Review")

Step 3

Enter

Step 4

Use the fill handle to copy the result L6:L11

venereology answered 1 year ago

Next > < Previous

Related Solutions

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 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. 14 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. 15 Enter a function in cell E12, based on the payment and loan details, that calculates the amount...

On the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the principal of the loan that will be required to purchase the house.

Mortgage InformationAnnual Interest Rate4.90%Repayment Years30Price of House$275,000Down Payment$55,000Principal of LoanMonthly PaymentsOn the Mortgage worksheet, use the data provided to enter a formula in cell B6 to calculate the principal of the loan that will be required to purchase the house.On the Mortgage worksheet, use the PMT function in cell B7 to calculate the monthly payments of the mortgage. Use cell locations from this worksheet to define each argument of the function. Assume that payments are made at the end of...

Subjects