Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Data for Forecasting and Valuation 2007 Financial Statements See Basic Statements Tab 2008 Projected Sales Growth 2007 Sales Probabilty Pessimistic times 2 0.20 Most Likely

Data for Forecasting and Valuation 2007 Financial Statements See Basic Statements Tab 2008 Projected Sales Growth 2007 Sales Probabilty Pessimistic times 2 0.20 Most Likely times 3 0.65 Optimistic times 4 0.15 Expected Value Projected Sales Growth 2009 2010 2011 2012 2013 Increase Over Previous Year 0.60 0.45 0.25 0.15 0.08 NB: 2013 is the Terminal Year Other Information: Income Statement Salaries and Wages Reduce salaries and wages to sales ratio by 25% of 2007 to reflect improved efficiences Selling and Marketing Expenses Increase selling and marketing expenses to sales ratio by 4 times that of 2007 to reflect increased spending to support sales growth Interest Expense Reduce interest expense to sales ratio of 2007 by 50% to reflect lower borrowing costs Tax rate 35.00% Other Information: Balance Sheet Income Tax Receivable Hold constant - i.e. do not change with sales Deffered Income Tax Asset Hold constant - i.e. do not change with sales Property Plant & Equipment Reduce property plant & equipment to sales ratio to two thirds of 2007 to reflect outsourcing of production Lines of Credit Increase in line with sales Deferred Revenue Hold constant - i.e. do not change with sales Loan from Stockholder Hold constant - i.e. do not change with sales Defferred Income Tax Liability Hold constant - i.e. do not change with sales Common Stock on Issue Hold constant - i.e. do not change with sales Preferred Stock on Issue Hold constant - i.e. do not change with sales Additional Paid-In Capital Hold constant - i.e. do not change with sales Check Numbers for Solution Net Income/(Loss) for 2008 Projection $664,722 Cash balance as at end of 2008 $153,878 Cumulative Retained Earnings for 2013 $9,918,087 Eco-Products, Inc. Financial Statements and Projections [In Dollars] Actual Yearend Income Statements 2007 Net Revenues 10867104 Cost of Goods Sold 7726455 Gross Profit 3140649 Operating Expenses Bad Debt 141 Depreciation and Amortization 87563 Employee Benefits 114011 General and Administrative 494061 Payroll Taxes 117557 Occupancy Expense 349668 Repairs and Maintenance 27140 Salaries and Wages 1778282 Selling and Marketing Expenses 43783 Total Operating Expenses 3012206 Operating Profit 128443 Other Income and (Expenses) Interest Expense -186726 Other Income 0 Other Expense -1192 Net Other Income & (Expenses) -187918 Net Income (Loss) Before Taxes -59475 Provision for Income Taxes Current Tax Benefit 52276 Deferred Tax Expense -29000 Total Provision of Income Taxes 23276 Net Income (Loss) -36199 Balance Sheets 2007 Assets Current Assets Cash 51667 Accounts Receivable, Net 1330562 Prepaid Expenses & Other Cur. Assets 728776 Income Tax Receivable 54506 Inventory 2415916 Deferred Income Tax Asset 42000 Total Current Assets 4623427 Property and Equipment Machinery and Equipment 641773 Building Improvements 479481 Vehicles 228448 Total Property and Equipment 1349702 Less Accumulated Depreciation -360304 Net Property and Equipment 989398 Intangible Assets Trademarks 20800 Other Intangible Assets 5440 Total Intangible Assets 26240 Less Accumulated Amortization -2050 Net Intangible Assets 24190 Other Assets Deposits 10000 Total Assets 5647015 2007 Liabilities and Equity Current Liabilities Accounts Payable & Accrued Expenses 568131 Accrued Payroll & Payroll Taxes 6712 Accrued Vacation 39356 Lines of Credit 2843242 Current Portion of Long-Term Debt 39865 Current Portion of Capital Leases 37919 Deferred Revenue 105588 Loan from Stockholder 93394 Other Current Liabilities 21523 Total Current Liabilities 3755730 Deferred Income Tax Liability 54000 Deferred Lease Liability 36383 Long-Term Capital Leases, Net of Current Por. 141228 Long-term Debt, Net of Current Portion 124546 Total Liabilities 4111887 Stockholders' Equity Common Stock, $.001 Par Value 50,000,000 Shares Authorized 16,935,000 Shares Issued & Outstanding 156300 Preferred Stock, $.001 Par Value 1,750,000 Shares Authorized 1,366,666 Shares Issued & Outstanding 0 Additional Paid-In-Capital 1269908 Retained Earnings 108920 Total Stockholders' Equity 1535128 Total Liabilities & Stockholders' Equity 5647015 Can you please help me to compute 2008 to 2013 balanced sheet and income statement

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

More Books

Students also viewed these Accounting questions

Question

Y y = m (x x1); y = 4, y1 = 7, x = 1, x1 = 5 (equation of a line)

Answered: 1 week ago

Question

Is SHRD compatible with individual career aspirations

Answered: 1 week ago