Question

In: Accounting

Use the financial information below to construct a 2010 income statement and balance sheets for both...

  1. Use the financial information below to construct a 2010 income statement and balance sheets for both 2009 and 2010. The firm’s average tax rate is 40% and its plowback ratio is 60%. Find the firms’ cash flows (OCF, NCS, change in NWC, FCF, CFC, CFS).

2009

2010

Sales ($ millions)

1000

1112

Cost of Goods Sold ($ millions)

500

556

Other Expenses ($ millions)

100

111

Depreciation ($ millions)

100

100

Interest Expense ($ millions)

50

55

Total Current Assets ($ millions)

600

700

Accumulated Depreciation

200

300

Net Fixed Assets ($ millions)

1800

2000

Total Current Liabilities ($ millions)

450

550

Long-term Liabilities ($ millions)

900

975

Accumulated Retained Earnings

500

This can be determined from the information given.

Solutions

Expert Solution

Income statement
Particulars 2010 ($ millions) 2009 ($ millions)
Sales 1,112 1,000
Less-
Cost of goods sold 556 500
Other expenses 111 100
Depreciation 100 100
Interest expense 55 50
Profit before taxes 290 250
Less-Tax at 40% 116 100
Profit after taxes 174 150
Balance sheet
Particulars 2010 ($ millions) 2009 ($ millions)
Current assets 700 600
Gross Fixed assets 2,300 2,000
Less-Accumulated depreciation -300 -200
Total Assets 2,700 2,400
Current Liabilities 550 450
Long term liabilities 975 900
Accumulated retained earnings 674 500
Provision for Tax 116 100
Total Liabilities 2,315 1,950

Note - It is assumed that the retained earnings for 2009 is the closing retained earnings computed after taking that year's profit into account.Retained earnings of 2010 is calculated as Closing Retained earnings of 2009 + 2010's profit plowback (ie 500 + $ 174 = 674)

Gross fixed assets is computed as the sum of Net fixed asset and accumulated depreciation.

Since all the account balances are not provided it is not possible to tally the balance sheet.

Cash flows for 2010
Particulars Amount($ millions) Amount($ millions)
Operating activities
Profit before taxes 290
Less-Depreciation -100 190
Change in working capital
Increase in current assets -100
Increase in current liabilities 100 0
Financing Activites
Issue of Debt instruments (Movement in long term liabilities) 75
Investing Activites
Purchase of fixed assets (2300-2000) -300

Related Solutions

Use the information in the table below to construct an income statement for 2015 and balance...
Use the information in the table below to construct an income statement for 2015 and balance sheets for 2014 and 2015.  Then, find Operating Cash Flow, change in Net Working Capital, Net Capital Spending, Cash Flow to Creditors, Cash Flow to Shareholders, and Free Cash Flow.  The tax rate is 34% and the plowback ratio is 60%. 2014 2015 Sales 1700 Costs of Goods Sold 650 Depreciation Expense 200 Interest Expense 75 Total Fixed Assets 2200 3300 Accumulated Depreciation 400 Can be...
Use the information in the table below to construct an income statement for 2015 and balance...
Use the information in the table below to construct an income statement for 2015 and balance sheets for 2014 and 2015.  Then, find Operating Cash Flow, change in Net Working Capital, Net Capital Spending, Cash Flow to Creditors, Cash Flow to Shareholders, and Free Cash Flow.  The tax rate is 34% and the plowback ratio is 60%. 2014 2015 Sales 1700 Costs of Goods Sold 650 Depreciation Expense 200 Interest Expense 75 Total Fixed Assets 2200 3300 Accumulated Depreciation 400 Can be...
Based on the following financial information, construct the balance sheet and income statement below for Tonka...
Based on the following financial information, construct the balance sheet and income statement below for Tonka Trucking LLC for the year ending December 31, 2019. Be sure to format them as accurately as possible. Accounts Receivable $40,000 Depreciation Expense $50,000 Accumulated Depreciation $200,000 Cost of Goods Sold $50,000 Income Tax Expense $50,000 Cash $50,000 Sales Revenue $400,000 Equipment (Net of Accumulation) $200,000 Selling, General, and Administrative Expenses $100,000 Common Stock (1,000 shares) $100,000 Accounts Payable $50,000 Retained Earnings $200,000 Interest...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE...
USE THE FOLLOWING INFORMATION TO CONSTRUCT AN INCOME STATEMENT AND BALANCE SHEET FOR 2011. ASSUME THE TAX RATE IS 40%. (COMMON EQUITY IS A PLUG IN NUMBER) ITEM 2010 2011 SALES 10,000 12,000 DEPRECIATION 3,000 3,000 COST OF GOODS SOLD 2,000 2,000 OTHER EXPENSES 3,000 4,000 INTEREST 1,000 1,000 CASH 1,000 1,000 ACCOUNTS RECEIVABLE 3,000 3,000 S.T. NOTES PAYABLE 1,000 1,000 L.T. DEBT 10,000 11,000 NET FIXED ASSETS 20,000 20,000 ACCOUNTS PAYABLE 2,000 2,000 INVENTORY 3,000 3,000 DIVIDENDS 600 600...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 443555 Operating Costs 326133 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 54355 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 64355 Prepare an income statement and a balance sheet for is company using the information provided. Calculate: 1. Current ratio 2. Quick ratio 3. NWC-to-total-Assets (Working capital to assets) 4. Ratio...
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below....
Below are numbers from a balance sheet and income statement. Construct the financial ratios requested below. Sales 499891 Operating Costs 359935 Depreciation 10000 Interest Expense 5000 Tax Expense 29408 Cash 1000 Receivables 30000 Inventories 59989 Fixed Assets, Net 50000 Payables 11000 Accrued Expenses 10000 Long-Term Loan 50000 Common Equity 69989 6. Interest coverage 7. Net profit margin 8. Sales to total assets (Asset turnover) 9. Return on assets 10. Equity multiplier 11. Return on equity
The income statement, balance sheets, and additional information for Great Adventures, Inc., are provided below.                  ...
The income statement, balance sheets, and additional information for Great Adventures, Inc., are provided below.                   GREAT ADVENTURES, INC. Income Statement For the Year Ended December 31, 2020   Revenues:      Service revenue (clinic, racing, TEAM) $ 547,000              Sales revenue (MU watches) 122,000                Total revenues $ 669,000         Expenses:          Cost of goods sold (watches) 72,000                  Operating expenses 304,476                  Depreciation expense 52,000                  Interest expense 29,924                  Income tax expense 58,200                     Total expenses 516,600         Net income $ 152,400...
The income statement, balance sheets, and additional information for Great Adventures, Inc., are provided below.                  ...
The income statement, balance sheets, and additional information for Great Adventures, Inc., are provided below.                   GREAT ADVENTURES, INC. Income Statement For the Year Ended December 31, 2020   Revenues:      Service revenue (clinic, racing, TEAM) $ 547,000              Sales revenue (MU watches) 122,000                Total revenues $ 669,000         Expenses:          Cost of goods sold (watches) 72,000                  Operating expenses 304,476                  Depreciation expense 52,000                  Interest expense 29,924                  Income tax expense 58,200                     Total expenses 516,600         Net income $ 152,400...
The income statement, balance sheets, and additional information for Great Adventures, Inc., are provided below.                  ...
The income statement, balance sheets, and additional information for Great Adventures, Inc., are provided below.                   GREAT ADVENTURES, INC. Income Statement For the Year Ended December 31, 2020   Revenues:      Service revenue (clinic, racing, TEAM) $ 555,000              Sales revenue (MU watches) 130,000                Total revenues $ 685,000         Expenses:          Cost of goods sold (watches) 76,000                  Operating expenses 304,876                  Depreciation expense 56,000                  Interest expense 30,324                  Income tax expense 60,600                     Total expenses 527,800         Net income $ 157,200...
Use the following information for the remaining problems. First, construct an income statement and two balance...
Use the following information for the remaining problems. First, construct an income statement and two balance sheets. Enter all answers as whole dollar numbers with no $ or commas (e.g. 20000). 2015 Sales = $60,000 2015 COGS = $25,000 2015 SG&A Expense = $10,000 2015 Depreciation Expense = $5,000 2015 Interest Expense = $3,000 Average Tax Rate = 30% Dividend Payout Ratio = 55% 2015 Current Assets = $24,000 and 2016 Current Assets = $27,000 2015 Net Working Capital =...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT