Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1) 2) 3) 4) Looking at these four gas stations, which one would you buy and why? (Please answer in detail) (Dont copy paste) Branded
1)
2)
3)
4)
Looking at these four gas stations, which one would you buy and why? (Please answer in detail)
(Dont copy paste)
Branded Gas Station Summary of 12 months as of Sep, 2019 Type of Revenue Margin % Sales Margin $ $534,800 Store Merchandise $1,980,000 27.0% ATM Lottery Commission Fees & Rebate Air/Vac $38,400 $12,000 $38,000 $5.700 100 0% 100 096 100.0% 100.0% $38,400 $12.000 $38,000 $5,700 Total Inside $2,074,100 $628,700 $0.15 $0.25 $105,000 $0 Fuel Gallons Deisel Sales Fuel Sales in Dollars Deisel Fuel Sales in Dollars Total Sales in Dollars Total Gross Margin Operating Expense: 700000 0 $1,750,000 SO $3,824,100 $733,700 Inc Manager without property prohase Payroll $165,000 Payroll Taxes $18,150 Merchant Bank Services $36,000 Utilities Electric/Gas $20,000 Fees & Licenses $3,500 Rent Bank Payments $120,000 Telephone, Water, Trash $4,000 Real Estate Tax $0,500 Repair & Mainstance $2.500 DSL/Aram/MISC $4,000 Professional Fees $2.400 Insurance $3,200 Supplies & Miscellaneous $2.500 Total Operating Expense $390,750 Net Operating Income Debt service SBA backed loan (6.7%, 300 mo) Seller Note (9%, 80 mo) Total Debt Service Manager Salary Return on Investment Buyer's Cash Investment Return on Investment Percentagel year Property: $390,750 $342,950 0 0 0 x 12 $36,000 $378,950 $1,900,000 19.9% Included Unbranded Gas Station Summary of 12 months as of Dec, 2019 Type of Revenue Sales Margin % Merchandise Sales $900,000 25.0% Hot Food and Deli $380,000 55.0% Margin $ $225,000 $198.000 ATM Lottery Commission Fees & Rebate Air/Vac Check Cashing $15,000 $75,000 $15,000 $1,200 $150,000 100.0% 100.0% 100.0% 100.0% 100.0% $15,000 $75,000 $15,000 $1,200 $150.000 Total Inside $1.516,200 $679,200 $0.12 $0.25 $108,000 $0 Fuel Gallons Deisel Sales Fuel Sales in Dollars Deisel Fuel Sales in Dollars Total Sales in Dollars Total Gross Margin Operating Expense: 900000 0 $2,250.000 $0 $3,766,200 $787 200 Ino Manager Inc UST 12k/m Payroll $175.000 Payroll Taxes $19,250 Merchant Bank Services $40,000 Utilities Electric/Gas $23,000 Fees & Licenses $3,500 Rent/Bank Payments $144,000 Telephone, Water, Trash $4,800 Real Estate Tax $7,500 Repair & Mainatance $3,500 DSL/Aram/MISC $3,600 Professional Fees $2,400 Insurance $5,000 Supplies & Miscellaneous $12,500 Total Operating Expense $444,050 Net Operating Income Debt service SBA backed loan (6.7%, 300 mo) Seller Note (9%, 80 mo) Total Debt Service Manager Salary Return on Investment Buyer's Cash Investment Return on Investment Percentagel year Property $444,050 $343,150 0 O x 12 $24.000 $367,150 $395,000 92.9% Branded (BP) Gas Station Summary of 12 months as of November, 2019 Type of Revenue Margin % Merchandise Sales $950,000 25.0% Sales Margin $ $237,500 ATM Lottery Commission Fees & Rebate Air/Vac $12,000 $24,000 $20,000 $7.200 100.0% 100.0% 100.0% 100.0% $12,000 $24,000 $20,000 $7,200 Total Inside 1,013,200 0.700 $0.20 $0.25 $190,000 $0 Fuel Gallons Deisel Sales Fuel Sales in Dollars Deisel Fuel Sales in Dollars Total Sales in Dollars Total Gross Margin Operating Expense: 950000 0 $2,375,000 $0 $3,388,200 $490,700 Ino Manager With Property Payroll $130.000 Payroll Taxes $14,300 Merchant Bank Services $42.000 Utilities Electric/Gas $18,000 Fees & Licenses $3,500 Rent/Bank Payments SO Telephone, Water, Trash $4,500 Real Estate Tax $12,000 Repair & Mainatance $2,500 DSL/Aram/MISC $4,000 Professional Fees $2.400 Insurance $3,000 Supplies & Miscellaneous $2,500 Total Operating Expense $238,700 Net Operating Income Debt service SBA backed loan (6.7%, 300 mo) Seller Note (9%, 60 mo) Total Debt Service Manager Salary Return on Investment Buyer's Cash Investment Return on Investment Percentagel year Property Included $238,700 $252,000 0 0 0x 12 $36.000 $288,000 $1,500,000 19.2% $0 Unbranded Gas Station Summary of 12 months as of June, 2020 Type of Revenue Sales Margin % Merchandise Sales $1,800,000 25.0% Fast Food Operation $350,000 85.0% Margin $ $400,000 $227,500 ATM Lottery Commission Fees & Rebate Air/Vac Check cashing $38,000 $33,000 $30,000 $1,200 $300,000 100.0% 100.0% 100.0% 100.0% 100.0% $38,000 $33,000 $30,000 $1,200 $300,000 Total Inside $2,350,200 $1,027 700 $0.20 $0.25 $12,000 $0 Fuel Gallons Deisel Sales Fuel Sales in Dollars Deisel Fuel Sales in Dollars Total Sales in Dollars Total Gross Margin Operating Expense: 60000 0 $150,000 SO $2,500,200 $1,039,700 Ino Manager Payroll $288,000 Payroll Taxes $31,680 Merchant Bank Services $12,000 Utilities Electric/Gas $27,000 Fees & Licenses $3,500 Rent/Bank Payments $84,000 Telephone, Water, Trash $5,000 Real Estate Tax $5,000 Repair & Mainstance $3,500 DSL/Aram/MISC $4.000 Professional Fees $2.400 Insurance $6.250 Supplies & Miscellaneous $6.500 Total Operating Expense $478,830 Net Operating Income Debt service SBA backed loan (6.7%, 300 mo) Seller Note (9%, 80 mo) Total Debt Service Manager Salary Return on Investment Buyer's Cash Investment Return on Investment Percentagel year Property $478,830 $560,870 O 0 0 x 12 $40,000 $600,870 $750,000 80.1% not inc Branded Gas Station Summary of 12 months as of Sep, 2019 Type of Revenue Margin % Sales Margin $ $534,800 Store Merchandise $1,980,000 27.0% ATM Lottery Commission Fees & Rebate Air/Vac $38,400 $12,000 $38,000 $5.700 100 0% 100 096 100.0% 100.0% $38,400 $12.000 $38,000 $5,700 Total Inside $2,074,100 $628,700 $0.15 $0.25 $105,000 $0 Fuel Gallons Deisel Sales Fuel Sales in Dollars Deisel Fuel Sales in Dollars Total Sales in Dollars Total Gross Margin Operating Expense: 700000 0 $1,750,000 SO $3,824,100 $733,700 Inc Manager without property prohase Payroll $165,000 Payroll Taxes $18,150 Merchant Bank Services $36,000 Utilities Electric/Gas $20,000 Fees & Licenses $3,500 Rent Bank Payments $120,000 Telephone, Water, Trash $4,000 Real Estate Tax $0,500 Repair & Mainstance $2.500 DSL/Aram/MISC $4,000 Professional Fees $2.400 Insurance $3,200 Supplies & Miscellaneous $2.500 Total Operating Expense $390,750 Net Operating Income Debt service SBA backed loan (6.7%, 300 mo) Seller Note (9%, 80 mo) Total Debt Service Manager Salary Return on Investment Buyer's Cash Investment Return on Investment Percentagel year Property: $390,750 $342,950 0 0 0 x 12 $36,000 $378,950 $1,900,000 19.9% Included Unbranded Gas Station Summary of 12 months as of Dec, 2019 Type of Revenue Sales Margin % Merchandise Sales $900,000 25.0% Hot Food and Deli $380,000 55.0% Margin $ $225,000 $198.000 ATM Lottery Commission Fees & Rebate Air/Vac Check Cashing $15,000 $75,000 $15,000 $1,200 $150,000 100.0% 100.0% 100.0% 100.0% 100.0% $15,000 $75,000 $15,000 $1,200 $150.000 Total Inside $1.516,200 $679,200 $0.12 $0.25 $108,000 $0 Fuel Gallons Deisel Sales Fuel Sales in Dollars Deisel Fuel Sales in Dollars Total Sales in Dollars Total Gross Margin Operating Expense: 900000 0 $2,250.000 $0 $3,766,200 $787 200 Ino Manager Inc UST 12k/m Payroll $175.000 Payroll Taxes $19,250 Merchant Bank Services $40,000 Utilities Electric/Gas $23,000 Fees & Licenses $3,500 Rent/Bank Payments $144,000 Telephone, Water, Trash $4,800 Real Estate Tax $7,500 Repair & Mainatance $3,500 DSL/Aram/MISC $3,600 Professional Fees $2,400 Insurance $5,000 Supplies & Miscellaneous $12,500 Total Operating Expense $444,050 Net Operating Income Debt service SBA backed loan (6.7%, 300 mo) Seller Note (9%, 80 mo) Total Debt Service Manager Salary Return on Investment Buyer's Cash Investment Return on Investment Percentagel year Property $444,050 $343,150 0 O x 12 $24.000 $367,150 $395,000 92.9% Branded (BP) Gas Station Summary of 12 months as of November, 2019 Type of Revenue Margin % Merchandise Sales $950,000 25.0% Sales Margin $ $237,500 ATM Lottery Commission Fees & Rebate Air/Vac $12,000 $24,000 $20,000 $7.200 100.0% 100.0% 100.0% 100.0% $12,000 $24,000 $20,000 $7,200 Total Inside 1,013,200 0.700 $0.20 $0.25 $190,000 $0 Fuel Gallons Deisel Sales Fuel Sales in Dollars Deisel Fuel Sales in Dollars Total Sales in Dollars Total Gross Margin Operating Expense: 950000 0 $2,375,000 $0 $3,388,200 $490,700 Ino Manager With Property Payroll $130.000 Payroll Taxes $14,300 Merchant Bank Services $42.000 Utilities Electric/Gas $18,000 Fees & Licenses $3,500 Rent/Bank Payments SO Telephone, Water, Trash $4,500 Real Estate Tax $12,000 Repair & Mainatance $2,500 DSL/Aram/MISC $4,000 Professional Fees $2.400 Insurance $3,000 Supplies & Miscellaneous $2,500 Total Operating Expense $238,700 Net Operating Income Debt service SBA backed loan (6.7%, 300 mo) Seller Note (9%, 60 mo) Total Debt Service Manager Salary Return on Investment Buyer's Cash Investment Return on Investment Percentagel year Property Included $238,700 $252,000 0 0 0x 12 $36.000 $288,000 $1,500,000 19.2% $0 Unbranded Gas Station Summary of 12 months as of June, 2020 Type of Revenue Sales Margin % Merchandise Sales $1,800,000 25.0% Fast Food Operation $350,000 85.0% Margin $ $400,000 $227,500 ATM Lottery Commission Fees & Rebate Air/Vac Check cashing $38,000 $33,000 $30,000 $1,200 $300,000 100.0% 100.0% 100.0% 100.0% 100.0% $38,000 $33,000 $30,000 $1,200 $300,000 Total Inside $2,350,200 $1,027 700 $0.20 $0.25 $12,000 $0 Fuel Gallons Deisel Sales Fuel Sales in Dollars Deisel Fuel Sales in Dollars Total Sales in Dollars Total Gross Margin Operating Expense: 60000 0 $150,000 SO $2,500,200 $1,039,700 Ino Manager Payroll $288,000 Payroll Taxes $31,680 Merchant Bank Services $12,000 Utilities Electric/Gas $27,000 Fees & Licenses $3,500 Rent/Bank Payments $84,000 Telephone, Water, Trash $5,000 Real Estate Tax $5,000 Repair & Mainstance $3,500 DSL/Aram/MISC $4.000 Professional Fees $2.400 Insurance $6.250 Supplies & Miscellaneous $6.500 Total Operating Expense $478,830 Net Operating Income Debt service SBA backed loan (6.7%, 300 mo) Seller Note (9%, 80 mo) Total Debt Service Manager Salary Return on Investment Buyer's Cash Investment Return on Investment Percentagel year Property $478,830 $560,870 O 0 0 x 12 $40,000 $600,870 $750,000 80.1% not incStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started