Estimate revenues from year 1 to year 5 based on the following assumptions: . Current Market...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 year's 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 Year is $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 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 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 . W 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 6 Estimate a projected four-year Cash Flow Statement, based on the above assumptions 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 • Assume a target Leverage Ratio as being equal to 120% Assume a target Retention Ratio as being equal to 40%. . I 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 year's 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 Year is $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 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 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 . W 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 6 Estimate a projected four-year Cash Flow Statement, based on the above assumptions 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 • Assume a target Leverage Ratio as being equal to 120% Assume a target Retention Ratio as being equal to 40%. . I
Expert Answer:
Answer rating: 100% (QA)
Task 1 Estimate Revenues Assumptions Current Market Volume Units 72000000 Current Unit Price 600 Annual Estimated Volume Growth Rate 3 Targeted Market Share First Year 05 Second Year 2 Third Year 4 Fo... View the full answer
Posted Date:
Students also viewed these finance questions
-
Based on the following scenario, role-play a decision-making meeting using effective communication skills and group decision-making processes. The decision-making role-playing may be conducted as a...
-
Based on the following accounts, calculate (a) Net sales, (b) Cost of goods sold, (c) Gross profit, (d) Net income. Accounts Payable .................. $ 6,400 Operating Expenses .....................
-
Based on the following image: a. Explain where the charges should be applied to this gel in order for the DNA samples to migrate properly. b. Identify the largest DNA fragment in sample 5. Explain...
-
Copper Products Limited leases property on which copper has been discovered. The lease provides for an immediate payment of $472,000 to the lessor before drilling has begun and an annual rental of...
-
Why would a company institute a control policy that required mandatory vacations?
-
The Sofaworld Company purchases upholstery material from Barrett Textiles. The company uses 45,000 yards of material per year to make sofas. The cost of ordering material from the textile company is...
-
Kelly Berryman Inc. reported 2000 earnings per share of \($3.26\) and had no extraordinary items. In 2001 earnings per share on income before extraordinary items was \($2.99\). and earnings per share...
-
Mid-States Metal Finishers produces steel tubing at its Akron plant. The plants quality assurance officer prepares a monthly report and sends it to headquarters. The data compiled in these reports...
-
of 21 Required information Problem 17-5A (Algo) Comparative ratio analysis LO P3 [The following information applies to the questions displayed below] Summary information from the financial statements...
-
Find all (real) values of k for which A is diagonalizable. k A = | 0 2 0
-
FACTS On March 3, 1997, Shokott from Davao purchased two (2) brand new industrial refrigerators from XY Company (XYC) in Manila through its employee Mangtomas, amounting to a total of Php100,000.00....
-
1.help analyze the strict limit allocation operations by the ministry to the exchequer management reinforcement 2.what happens in the overspending criterion for the approval of excess recovery in the...
-
Determine the meaning of words and phrases as they are used in the text, including figurative and connotative meanings. In the figurative language inAct IV, Scene iii, lines 39-41, of The Tragedy of...
-
Runge Company purchased machinery on January 1 at a list price of $300,000, with credit terms 2/10, n/30. Payment was made within the discount period. Runge paid $15,000 sales tax on the machinery...
-
Write a function to find the shortest path between two nodes in a graph using Dijkstra's algorithm.
-
Jackson Co. has the following information for the first 4 months of this year: Machine hours Cleaning Hours Expense January 2,100. $900 February 2,600 1,200 March 1,600 800 April 2,000 1,000...
-
Current Attempt in Progress The following, listed in alphabetical order, are the adjusted accounts of Oriole Inc. as of December 31.2022: Accounts Payable $4.290, Accounts Receivable $1,870,...
-
Cornell and Roberts are partners who agree to admit Stanley to their partnership. Cornell has a capital balance of $80,000 and Roberts has a capital balance of $120,000. Cornell and Roberts share net...
-
What is the popular saying on which the cash flow fade method is founded?
-
Should the buyers costs be separated from the target companys costs in the cost savings that come out of a merger of two companies?
-
What is the cost of capital equal to?
Study smarter with the SolutionInn App