|
|
This assignment is due at the conclusion of class on November 19th. You MUST use conditional formulas (=IF) to calculate potential borrowing or repayment of debt in the cash budget. No credit [zero, zip, nada] will be given for work that does not include the =IF( ) functions. Assume that any borrowing occurs at the beginning of a given month and repayment is at the end of a month. Borrowing and repayment never occur in the same month. Interest accrued in one month is paid in the next month. Refer to the PowerPoint slides on using conditional formulas in debt transactions, cited above. Your completed spreadsheet model You have all the numbers, so you will know when you have the correct formulas. The full details of the assignment are provided in an Acrobat file available here. This includes the text of the case and the Acrobat printout of my solution. |
Copyright © 2008 Gerald M. Myers
|