Assignment:
Using your existing excel spreadsheet, find the tabs labeled “Sources & Uses”, “Cash Flow,” “Sale,” and “Amortization.”
Locate the “Cash Flow” tab and complete the analysis. Please keep in mind that your project may have a negative cash flow. If so, the next assignment will attempt to provide creative solutions to mitigate this.
Using the loan termsand amortization tabs provided by your “lender”, complete the table on the “Amortization” tab.
Finish the calculations on the “Sale” tab.
Review the “Sources & Uses” tab and determine the equity to debt ratio.
Save alltabs of your spreadsheet and submit to instructors as a PDF. 10 Points
