Question: (06 pts) In cell E3, write an Excel function which can be copied down the column into cells E4:E7 to show the actual loan amount

(06 pts) In cell E3, write an Excel function
(06 pts) In cell E3, write an Excel function which can be copied down the column into cells E4:E7 to show the actual loan amount rounded to nearest whole number or dollar . The loan amount is what you need to borrow from the bank after you have paid the specified down payment. Do not use a Financial Function. (Hint: multiply the selling price in column B by (1 minus the percent down in column D ) and use the ROUND () function to round this to the nearest whole number. Remember to check if you need a 5 in one or more of the numbers in the cells used since you are copying this down.). =ROUND (selling price * (1 - % down), round to the nearest whole number) =ROUND( * (2 - J. 0)

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 Mathematics Questions!