Answered step by step
Verified Expert Solution
Link Copied!

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) Branded Gas Station Summary

1)

image text in transcribed

2)

image text in transcribed

3)

image text in transcribed

4)

image text in transcribed

Looking at these four gas stations, which one would you buy and why? (Please answer in detail)

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The New Public Finance

Authors: Inge Kaul, Pedro Condeicao

1st Edition

0195179978, 978-0195179972

More Books

Students also viewed these Finance questions