Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please answer task 4 Task 1 Estimate revenues from year 1 to year 5 based on the following assumptions: Current Market Volume Units: 72,000,000 Current

Please answer task 4 Task 1 Estimate revenues from year 1 to year 5 based on the following assumptions: Current Market Volume Units: 72,000,000 Current Unit Price: $6.00 Annual Estimated Volume Growth Rate: 3% Targeted Market Share: o First Year 0.5% o Second Year 2% o Third Year 4% o Fourth Year 4% o Fifth Year 4% Accounts Receivable is estimated to be 10% of Sales. Prior to the First Year there were no Sales.

Task 2: Estimate the COGS, Inventories, Purchases and Accounts Payable from year 1 to year 4 Unit Sales Price is a 60% mark up on the Unit Cost of Goods Sold You plan to hold Inventories equal to 30% of your estimate for next years Sales You pay for 92% of Purchases in the year in which they were purchased and the remainder in the following year. Inventory at the beginning of the First Yearis $1,000,000.

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 equalsto 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.

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

Structured Finance And Insurance

Authors: Christopher L. Culp

2nd Edition

0471706310, 978-0471706311

More Books

Students also viewed these Finance questions

Question

Evaluate the importance of the employee handbook.

Answered: 1 week ago

Question

Discuss the steps in the progressive discipline approach.

Answered: 1 week ago