Real Estate Company Needs Help Managing Mortgage Debt - $20MM debt portfolio
See more projectsIntensity
5hr/week
Est. Duration
12months
Location
Remote
Project Overview
1 to 8 years professional experience
Finance & Accounting - Corporate Finance
Need finance/CFO/banker to prepare the following:
1) Summary of real estate debt portfolio. It includes 8 loans totaling $20MM. Summary to include loan details, covenants, maturity, properties, etc.
2) Graph model amount of debt coming due each year over the next 10 years.
3) Prepare worksheets for reviewing debt covenants.
4) Utilize budgets for project year-end debt covenant review.
5) Prepare consolidated projection of balance sheet of cash flows throughout the year and update as needed.
Upon completion of above project - there will be needed quarterly updates/reviews and identification of properties with projected covenant issues at year end.
NOTE: I doubt this project is the hours that SpareHire is estimating (250 hours per year) - but that is all it would let me enter.
1) Summary of real estate debt portfolio. It includes 8 loans totaling $20MM. Summary to include loan details, covenants, maturity, properties, etc.
2) Graph model amount of debt coming due each year over the next 10 years.
3) Prepare worksheets for reviewing debt covenants.
4) Utilize budgets for project year-end debt covenant review.
5) Prepare consolidated projection of balance sheet of cash flows throughout the year and update as needed.
Upon completion of above project - there will be needed quarterly updates/reviews and identification of properties with projected covenant issues at year end.
NOTE: I doubt this project is the hours that SpareHire is estimating (250 hours per year) - but that is all it would let me enter.
Additional Notes
Experience with commercial real estate debt. Preferred Skills and Certifications
Functional
Corporate Finance
About The Client
Top Skills Hiring For
Financial Modeling
Financial Statement Preparation
Financial Planning & Analysis (FP&A)
Corporate Finance
$117K
Total Spent
8 years
Time On Graphite
2
Hiring Managers