Confused as to what it is wanting me to do and where to click. Home ACROBAT Cali
ID: 3725250 • Letter: C
Question
Confused as to what it is wanting me to do and where to click. Home ACROBAT Calibri Currency l@ Copy Format Painter BI u Cipboard Merge & Center . 1 $-5 , Font Alignment Number B12 Beta Manufacturing Facility Amortization Table Payment Details Loan Details 6 Payment 7 APR 8 Years 9 Pmts per Year $6,000.00 5.75% $312,227.32 0479% 60 Periodic Rate # of Payments 12 10 Payment Beginning Payment Number Balance Amount Interest Paid Repayment Balance Interest Principal Remaining Cumulative Cumulative Principal 12 13 14 15 16 17 18 19 20 2110 23 12 24 25 14 13 26 27 15 16 Insurance Scenario Summary Facilities Sales Inventory| Ready
Explanation / Answer
Reference is usually used when we have to refer to a cell in the same sheet. Lets say A and B are 2 cells.
B can be reference with A, this means whenever A changes B also will change.
In B12 type "=E6" as that's the initial opening balance the loan starts with.
In C12 type "=B6" as that's tha monthly payment amount for the loan.