Question: Please answer Task 6 only!!! Task 1 : Estimate revenues from year 1 to year 5 based on the following assumptions: Current Market Volume Units:
Please answer Task only!!!
Task : Estimate revenues from year to year based on the following assumptions: Current Market Volume Units: Current Unit Price: $ Annual Estimated Volume Growth Rate: Targeted Market Share: o First Year o Second Year o Third Year o Fourth Year o Fifth Year Accounts Receivable is estimated to be of Sales. Priorto the First Year there were no Sales.
Task : Estimate the COGS, Inventories, Purchases and Accounts Payable from year to year Unit Sales Price is a mark up on the Unit Cost of Goods Sold You plan to hold Inventories equal to of your estimate for next years Sales You pay for of Purchases in the year in which they were purchased and the remainder in the following year. Inventory atthe beginning ofthe First Yearis $
Task : Estimate Wage Expense, Accrued Liabilities and Selling and Administrative Expenses from year to year based on the following assumptions: Wage Expense equalsto 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 of sales and is paid in the year in which it occurs
Task : Estimate a projected fouryear Income Statement, based on the above assumptions and the following additional assumptions: Depreciation is estimated as being equalto of Gross Fixed Assets atthe end ofthe prior year. Interest Expense on Debt is at a rate of 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 of Earnings before Tax. Assume that any tax benefits are NOT carried forward to reduce future tax payable. Assume NO dividends aredeclared. You can use the balance sheet information from Task below, if needed.
Task : Estimate a projected fouryear 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 asfollows: Cash $; Inventories $; Gross Fixed Assets $; Debt $ and Owners Equity $ You should assume all other prior period Balance Sheet values were zero. Required cash is estimated to be of Sales. The businessrequires capital expenditure of $ a yearin each ofthe first two years. Assume the founder invests additional $ in the firstyear.
Task : Estimate a projected fouryear Cash Flow Statement, based on the above assumptions
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
