Question: I need help creating a detailed financial spreadsheet for my business project in my marketing class. I've attached my business plan, a template of how

I need help creating a detailed financial spreadsheet for my business project in my marketing class. I've attached my business plan, a template of how I'd like it structured, and another spreadsheet that I liked but didn't quite meet my needs?I liked its structure, though. Additionally, please base the spreadsheet on the format outlined in the link I provided.

Key points to include: - Use Winston-Salem's market data for accurate pricing. - Travel nurses pay $1,100/month, while general renters pay $1,200/month. - Revenue and expenses should be categorized for both customer types. - Projections should be broken down into 6 months, 1 year, 2 years, 3 years, and up to 5 years. - Factor in when mortgage payments on my first property will end and when I can reinvest in a second property, aiming to scale up within 6 years.

I'd really appreciate your help?thank you for your time!

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!