A restaurant owner sets up a sinking fund to purchase a new building to expand its business. The factor from the sinking fund table is stored in Cell B4 and the cost is in Cell B3. Which is the correct way to enter the formula for the periodic deposit using an absolute cell reference?
A) =B3*B4
B) =$B3*$B4
C) =$B$3*B4
D) =B3*$B$4
Correct Answer:
Verified
Q24: A $1,900 bond at a 11.65% interest
Q25: A $2,200 bond at a 10.9% interest
Q26: A company reports net earnings of $3.10
Q27: An Excel spreadsheet contains the following information
Q28: Dale wants to have $50,000 in his
Q30: Face value is the amount of money
Q31: The present value of an annuity is
Q32: Juan deposited $350 quarterly at a rate
Q33: What is the present value of yearly
Q34: Tasha deposited $800 annually at a rate
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents