Populate assumptions from Word document to cells B3 to B13.

1. Populate assumptions from Word document to cells B3 to B13

2. Create a cash flow schedule starting at cell E23. If you create the cash flows according to line item descriptions, the preferred equity section will work.

3. Create a small debt schedule starting at cell C57. Your results in the schedule should be referenced back to the cash flow schedule.