Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task 3: Estimate Wage Expense, Accrued Liabilities and Selling and Administrative Expenses from year 1 to year 4 based on the following assumptions: Wage Expense

Task 3: Estimate Wage Expense, Accrued Liabilities and Selling and Administrative Expenses from year 1 to year 4 based on the following assumptions:

Wage Expense equals to 8% of current year Sales

You pay wages monthly in arrears, meaning that you will only pay for eleven of the twelve months wages in the year in which they have been earned and will pay the remaining one month of wages earned in the last month of the current year in the following year.

Selling and Administrative Expenses, including rent is estimated to be 10% of sales and is paid in the year in which it occurs

Task 4: Estimate a projected four-year Income Statement, based on the above assumptions and the following additional assumptions:

Depreciation is estimated as being equal to 10% of Gross Fixed Assets at the end of the prior year.

Interest Expense on Debt is at a rate of 15% per annum and is estimated based on the Debt Balance and Additional Funds Needed (if any) estimated at the end of the prior year.

Tax is estimated as being expensed at 30% of Earnings before Tax. Assume that any tax benefits are NOT carried forward to reduce future tax payable.

Assume NO dividends are declared.

Task 5: Estimate a projected four-year Balance Sheet, based on the above assumptions and the following additional assumptions:

The Balance Sheet at the end of the year prior to First Year was comprised as follows: Cash $50,000; Inventories $1,000,000; Gross Fixed Assets $4,000,000; Debt $2,000,000 and Owners Equity $3,050,000. You should assume all other prior period Balance Sheet values were zero.

Required cash is estimated to be 1% of Sales.

The business requires capital expenditure of $500,000 a year in each of the first two years.

Assume the founder invests additional $2,000,000 in the first year.

Task 7: Estimate the sustainable growth rate as at the end of the fourth year, based on the following assumptions:

The sustainable Profit Margin is estimated to be equal to that estimated for the fourth year, based on the fourth year Net Income and Sales.

The sustainable Asset Turnover is estimated to be equal to that estimated for the fourth year, based on average Total Assets in year 3 and 4 and Sales in year 4.

Assume a target Leverage Ratio as being equal to 120%.

Assume a target Retention Ratio as being equalto 40%.

Task 8: Estimate the required return based on CAPM, based on the following assumptions:

Assume the Risk Free Rate equals 1.5%

Assume Beta equals 2.0

Assume a Market Risk Premium of 6.0% Task 9: Estimate the Terminal Value of the new venture as at the end of the fourth year, based on the following assumptions:

Equity Valuation Cash Flow = Net Income + Depreciation Change in Net Operating Working Capital (exclude surplus cash) Change in Gross Fixed Assets + Net Debt Issues

Assume the Equity Valuation Cash Flow grows at the sustainable growth rate estimated in Task 7 from year 5 onwards.

Use the required return estimate from Task 8.

Task 10: Estimate the Present Value of the venture.

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_2

Step: 3

blur-text-image_3

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

Mortgage Ripoffs And Money Savers

Authors: Carolyn Warren

1st Edition

0470097833, 978-0470097830

More Books

Students also viewed these Finance questions