Question

1.You and a partner are considering the purchase of a convenience store. The store has annual sales of $500,000 and is paying annual payroll of $100,000. The cost of goods sold every year is $150,000. The firm has miscellaneous expenses (taxes, insurance, garbage, electricity, natural gas, security, maintenance, property taxes, training, advertising, accounting fees, bank charges, etc.) of roughly $68,000 per year. If depreciation is equal to $16,054 per year what is the Earnings before taxes?

2.Suppose you conduct a sensitivity analysis and come up with the following results:

NPV                                       State of Economy            Probability

$201,679   Good                                     0.6

($50,000.00)                       Bad                                        0.4

What is the Expected NPV of the project?

3.Assume the following cash flows for a convenience store project you are considering, the initial outflow is $660,000 followed by ten operating cash flows $123,550 in years 1 to 10. You will also receive a terminal cash flow of $438,500 also at year 10.

Compute the IRR of the project given an interest rate of x (written as a decimal). Enter your answer as a decimal.

4.You and a partner are considering the purchase of a convenience store. You determine that net income is 108,550 and your only non cash flow item in the income statment is depreciation of $11,369. What is your operating cash flow?

5.You and a partner are considering the purchase of a convenience store. The store has weekly sales of $82,582 and is paying weekly payroll of $4,500. The cost of goods sold every week is $78,000. The firm has miscellaneous expenses (taxes, insurance, garbage, electricity, natural gas, security, maintenance, property taxes, training, advertising, accounting fees, bank charges, etc.) of roughly $3,000 per week. What are the annual sales for the conenience store?

6.Assume inflation is expected to be 9.1% over the next 10 years and that the expectation is reflected in the cost of capital. What would you expect next years sales to be provided that this years sales are expected to be $4,628,000?

7.You and a partner are considering the purchase of a convenience store.? The store has annual sales of $500,000 and is paying annual payroll of $100,000. The cost of goods sold every year is $150,000. The firm has miscellaneous expenses (taxes, insurance, garbage, electricity, natural gas, security, maintenance, property taxes, training, advertising, accounting fees, bank charges, etc.) of roughly $68,000 per year. If depreciation is equal to $15,000 per year and the tax rate is equal to 20% then what is the net income?

8.Assume that you sell the business for $250,000 and your current book value at the time of the sale is $209,458. You are taxed at a rate of 35%. What is your net sale price (i.e. sale price net of taxes)?

9.Assume the following cash flows for a convenience store project you are considering, the initial outflow is $661,404 followed by ten operating cash flows $123,550 in years 1 to 10. You will also receive a terminal cash flow of $438,500 also at year 10.

Compute the Payback of the project given an interest rate of 12%

10.Assume the following cash flows for a convenience store project you are considering, the initial outflow is $650,862 followed by ten operating cash flows $123,550 in years 1 to 10. You will also receive a terminal cash flow of $438,500 also at year 10.

Compute the NPV of the project given an interest rate of 12%.

Answer 1

1.You and a partner are considering the purchase of a convenience store. The store has annual sales of $500,000 and is paying annual payroll of $100,000. The cost of goods sold every year is $150,000. The firm has miscellaneous expenses (taxes, insurance, garbage, electricity, natural gas, security, maintenance, property taxes, training, advertising, accounting fees, bank charges, etc.) of roughly $68,000 per year. If depreciation is equal to $16,054 per year what is the Earnings before taxes?

Ans:

Sales ($) = 500,000

Sales-A	500,000
Annual payroll expense-B	(100,000)
COGS-C	(150,000)
other expense-D	(68,000)
Total Expense= E=B+C+D	(318,000)
EBITDA=F=A-E	182,000
Depreciation=G	(16,054)
PBT=F-G	165,946

Therefore, Earning before tax is equal to $165,946