Enhance Your Public Relations Strategy with Our Excel Pro Forma Template

Excel pro forma template for Public Relations

[Music] as you can see the model comes with an investor summary which is a printable two-page formatted summary with return calculations and high level metrics next is an error check tab which provides quick insights into the accuracy of your financial model the next tab is model outputs this is used for investor relations reports and packages and include sources uses Capital stack hypothetical investor returns unit mix outputs and more now is the assumptions tab this includes property details timing assumptions acquisition price exit operating annual inflation control debt and waterfall assumptions this tab also includes a sensitivity table the unit mix tab shows the ability to model various units and pricing structures Broken Out by each unit type the construction budget tab has the ability to control timing on each specific line item and select if the calculation is fixed dollar per square foot dollar per unit or percentage monthly cash flows this is a detailed monthly analysis of unlevered and levered cash flows annual cash flow tab is an output tab driven entirely by the monthly cash flow tab waterfall includes the number of tiers selected in the custom model builder and breaks out the returns by the LPN GP the sales comps is an output Tab and shows sales of comparable properties and surrounding area finally the model has a four librar curve used for floating rate debt contact us today so we can get to work on underwriting your transactions for your condominium projects I can't wait to work with you