Question: I need help creating a detailed financial spreadsheet for my marketing class business project. I've attached my business plan, a template for structure, and another

I need help creating a detailed financial spreadsheet for my marketing class business project. I've attached my business plan, a template for structure, and another spreadsheet I liked but didn't fully meet my needs. Please follow the format outlined in the provided link.

Key Requirements: Use Winston Salem market data for realistic pricing. Revenue Breakdown: Travel nurses ($1,100/month) vs. general renters ($1,200/month). Expense & Revenue Categories: Separate financial tracking for each customer type. Projections: Startup Phase: No revenue. 1 6 months, 1 3 years, 3 5 years, 5 10 years: Label the number of acquired units for each stage. Additional Financial Rows: Property value, home equity, and mortgage balance. Mortgage Timeline & Expansion: Track when my first mortgage ends and when I can reinvest in a second property?I will only purchase additional units once the first is profitable, then scale strategically.

I appreciate your help?thank you!

https://www.canva.com/design/DAGjidaLOvQ/B1szuiOVnsU0SsOjb1ff0A/edit?utm_content=DAGjidaLOvQ&utm_campaign=designshare&utm_medium=link2&utm_source=sharebutton

I need help creating a detailed financial
Category Revenue Travel Nurses (10 units @ $2,000/mo) Hospital Partnerships (Referrals) Agency Partnerships (Referrals) Regular Renters (5 units @ $1,800/mo) Total Revenue Fixed Expenses Property Acquisition (15 units) Furnishing (15 units) Utilities (Water, Electricity) Cleaning & Maintenance Insurance Marketing (Ads, Digital) Adobe Acrobat (Software) Variable Expenses Staff Salaries (2 employees) Owner Salary (CEO) Property Taxes Miscellaneous Total Expenses Net Profit/Loss 6 Months $120,000 $5,000 $2,500 $54,000 $181,500 $200,000 $75,000 $6,000 $4,800 $3,000 $6,000 $120 $30,000 $24,000 $3,750 $2,500 $355,170 ($173,670) 1 Year $240,000 $10,000 $5,000 $108,000 $363,000 $200,000 $75,000 $12,000 $9,600 $6,000 $12,000 $240 $60,000 $48,000 $7,500 $5,000 $435,340 ($72,340) 2 Years $480,000 $20,000 $10,000 $216,000 $726,000 $200,000 $75,000 $24,000 $19,200 $12,000 $24,000 $480 $120,000 $96,000 $15,000 $10,000 $795,680 ($69,680) 3 Years $720,000 $30,000 $15,000 $324,000 $1,089,000 $200,000 $75,000 $36,000 $28,800 $18,000 $36,000 $720 $180,000 $144,000 $22,500 $15,000 $1,056,020 $32,980 4 Years $960,000 $40,000 $20,000 $432,000 $1,452,000 $200,000 $75,000 $48,000 $38,400 $24,000 $48,000 $960 $240,000 $192,000 $30,000 $20,000 $1,216,360 $235,640 5 Years $1,200,000 $50,000 $25,000 $540,000 $1,815,000 $200,000 $75,000 $60,000 $48,000 $30,000 $60,000 $1,200 $300,000 $240,000 $37,500 $25,000 $1,376,700 $438,300

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!