Using the content in the feasibility excel sheet.

Required: Cash flow statement, Pro-forma Income statement, Pro-forma Balance sheet for NextGen Property Solutions Company which is a real Estate company that deals in house flipping and home resell in Toronto, Vancouver and Calgary. Use percentage estimations for things like taxes and interests. Basically creating a financial plan for NextGen. You make estimations but provide references please.

2024( from October to December)

Projection ( next 5 years )( possible outcomes)

FEASIBILITY MODEL This spreadsheet analyzes the feasibility of property flipping investments for NextGen Property Solutions in the Canadian(Toronto, Vancouver, Calgary) real estate market WhatIf Analysis dynamic/activity Input process output Terms Impressions: The total number of times people view our listing or ads Leads: Interested people who inquire about the lsting or schedule a viewing Qualified Leads: Leads that fit the target profile and show real purchasing intent. Converted Buyers: People who go through with the purchase. Closing costs: are the expenses and fees paid at the end of a real estate transaction, when ownership of the property is transferred from the seller to the buyer Holding costs: are the ongoing expenses incurred while a property is owned but not yet sold. Assumptions & Reference 'The estimated cost per property is $750,000. This es https://www.strawhomes.com/vancouver-housing-market-correction-2020-should-i-bu The estimated renovation cost per property is $50,000, based on data from https://www.springfinancial.ca/blog/homeowner-finances /cost-of-renovating-a-house-canada, which indicates that renovation expenses in Canada typically range from $15,000 to $200,000, depending on factors such as the property's ageand size https://wwwspringfinancial ca/blog/homeowner-finances/cost-of-renovating-a-house-canada 'The estimated impressions-to-leads conversion rate is 1%, based on industry data indicating that the real estate sector in Canada generally sees rates between 0.5% and 2.4% due to varied audience engagement levels com/blog/insight/conversio: https ruleranal rate-by-indust For property flipping, the leads-to-buyer conversion rate is estimated at 15% due to the high intent and commitment levels typically seen among motivated customers. Input Impressions Impressions to Leads Conversion Rat EXPENSES 10,000 1% per month per month Leads Leads to Qualified Leads Conversion rats 100 15% per month per month Qualified Leads Qualified Leads to Converted Buyers Conversion rats 15 15% per month per month Converted Buyers| 2 per month Average Purchase per buyer $1,000,000.00 Total Sales per month $2,000,000.00 Cost Per Propert] $. ate s informed by recent market data, which shows a 56% decrease in sales and a 10% drop in average property prices in Vancouver since April 2022. For example, the average condo price has fallen from $846,000 to approximately $758,000, a decrease of about $88,000, supporting this valuation. Net Revenue] $500,000.00 Profit/Loss $117,630.00 5 7 9 0 il 2 3 .\\ 5 7 8 k) 0 il 2 3 4 5 7 8 k) 0 il 2 3 F.\\ 5 7 8 ) 0 il 2 3 r 5 7 8 k) 0 il Project Manager General Contractor Administrative Assistant Scheduled Hours/Week Weekly Admin Assistant Cost Monthly Admin Assistant Cost Annual Admin Assistant Cost Cleaning Staff Scheduled Hours/Week Weekly Cleaning Staff Cost Monthly Cleaning Staff Cost Annual Cleaning Staff Cost Total Annual Labor Costs Total Monthly Labor Costs Salaried Salaried S 84,000.00 S 72,000.00 S 25.00 |Hourly 750.00 $ $ 3,000.00 Hourly $210,240.00 $ 17,520.00 Labor (Paid Per Property Basis) Skilled Laborers Real Estate Agent Real Estate Agent S 35,000.00 |Per Property Commision Per Property Sold $ 50,000.00 |Per Property Sold Total Labor (Paid Per Property Basis) $ 85,000.00 Operating Costs Office Rent Utilities Office Supplies Sales & Marketing Costs Holding Costs Renovation & Improvement Insurance Property Inspection fees Travel Expenses Closing Costs Total Monthly Operating Costs Total Operating Costs Per Property TOTAL EXPENSES PER MONTH TOTAL EXPENSES PER PROPERTY Monthly Monthly Monthly Per Property Per Property Per Property Monthly Per Property Monthly Per Property $ 13,250.00 $ 90,800.00 S 30,770.00 $175,800.00