Class, Fill out the blank cells on the Mortgage Payment assignment. TOP 1. You h
Class, Fill out the blank cells on the Mortgage Payment assignment.
1. You have a list of 5 loans A8-A12. The amount financed would be the House Cost minus the Down Payment. Use a formula and remember relative cell addressing when you copy it down.
2. The Rate per period use the formula mortgage rate (E8) / payments per year (B5). Remember copying down you want the house cost be be relative cell addressing where as B5 would have to be made absolute cell addressing also format your cell.
3. The # of Payment Periods you should use the formula the number of years(G8) * payments per year (B5). Again when copying make sure the number of years is relative cell addressing and the payments per year (B5) absolute cell addressing.
BOTTOM or Summary
Use FUNCTIONS, =SUM, =AVG, =MED, =MAX, =MIN and =COUNT
Make sure you fill in ALL the blank cells for House Cost Down Payment and Amount Financed
DO NOT CALCULATE ON PAPER AND ENTER THE NUMBER IN. BIG 0 FOR THAT.
Make sure the Mortgage Payment assignment is in the folder.
YOUTUBE ON INTRO TO SHEETS FUNCTIONS – CLICK ON LINK BELOW
https://www.youtube.com/watch?v=zNzw0Yzd8bU (Links to an external site.)
YOUTUBE ON MORE SHEETS FUNCTIONS – CLICK ON LINK BELOW