Preferred Equity Template EXCEL

Description

Use the information on the files provided to fill in the excel sheet.

  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.

Another file will be added to use for an example of the case study. The 10_30_19