I started a new position and this is a sample case study as this will become an ongoing assignment. I would just like a step by step refresher since I haven't had to do cashflows in some time. Thanks!
Attached are two documents. One file is the assignment (Word) and the other is the Excel file we will be pulling data from. I want to create a new tab in the Excel file for my solution.
Use Excel to create a monthly cash flow statement for calendar year 2023 (January through December) for the property with monthly revenue (market rent, gain/loss to lease, GRIV [Gross Rental Income Value], vacancy, net rental income), expenses, net operating income, capital expenditures and cash flow. Include a column for the full year total.
Assumptions and growth rate data will be found on the Word file.
Attached are two documents. One file is the assignment (Word) and the other is the Excel file we will be pulling data from. I want to create a new tab in the Excel file for my solution.
Use Excel to create a monthly cash flow statement for calendar year 2023 (January through December) for the property with monthly revenue (market rent, gain/loss to lease, GRIV [Gross Rental Income Value], vacancy, net rental income), expenses, net operating income, capital expenditures and cash flow. Include a column for the full year total.
Assumptions and growth rate data will be found on the Word file.