Microsoft Office Tutorials and References
In Depth Information
REVIEW OF EXCEL BASICS
Answers to the Questions about Borrowing and Repayment
Figures C-50 and C-51 display solutions for the borrowing and repayment calculations.
Answers to examples of borrowing
In Figure C-50, the formula in cell D2 for the amount to borrow is =IF(B2>=C2,0,C2-B2).
Answers to examples of repayment
In Figure C-51, the formula in cell E10 for the amount to repay is
Note the following points about the repayment calculations shown in Figure C-51.
In Example 1, only $2,000 is available for debt repayment ($12,000 – $10,000) to avoid dropping
below the Minimum Cash Required.
In Example 2, only $3,000 is available for debt repayment.
In Example 3, the Beginning-of-Year Debt was zero, so the Ending Cash is the same as the Net
In Example 4, there was enough cash to repay the entire $40,000 debt, leaving $20,000 in
In Example 5, the company has cash problems
it cannot repay any of the Beginning-of-Year
Debt of $10,000, and it will have to borrow an additional $30,000 to reach the Minimum Cash
Required target of $10,000.
You should now have all the basic tools you need to tackle Scenario Manager in Cases 6 and 7.