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.