Question

In: Accounting

has assembled statements and information to prepare financial plans for the coming year 20xx+1. Income Statement...

has assembled statements and information to prepare financial plans for the coming year 20xx+1. Income Statement For the year ended 30 December 20xx (Thousands of Dollars) Sales $36,000 Operating expenses 32,440 Earnings before interest and taxes $3,560 Interest 560 Pre-tax earnings $3,000 Taxes 1,200 Net income $1,800 Cash dividends 810 Addition to retained earnings $990 Balance Sheet 31 December 20xx (Thousands of Dollars) Assets Liabilities and equities Cash $1,080 Accounts payable $4,320 Marketable securities 500 Taxes payable 180 Account receivable 6,480 Notes payable 5,300 Inventory 9,000 Total current liabilities $9,800 Total current assets $17,060 Non-current debt 3,500 Net fixed assets 12,600 Ordinary shares 3,500 Total assets $29,660 Retained earnings 12,860 Total liabilities and equities $29,660 Information relating to financial projections for the year 20XX+1: 1) Sales are projected to increase by 15%. 2) The interest rate on all debt is 10%, and cash earns no interest income. 3) Currently Cardington is operating at full capacity. Net fixed assets will change in direct response to the change in sales. 4) Dividend payout ratio will remain unchanged. 5) Cash will halve and marketable securities will double. 6) Notes payable, non-current debt, and ordinary shares will remain unchanged. 7) Accounts receivable, inventory, and accounts payable will change in direct response to the change in sales. Required: Prepare a pro forma income statement for the year ending 31 December 20XX+1, and a pro forma balance sheet as of 31 December 20XX+1. Calculate the resulting external financing needed

Solutions

Expert Solution

Pro Forma income statement for the year ending 31 December 20XX+1

Particulars

Amount

Sales (3600*1.15)

41400

Operating expenses

(32440)

Interest (3500*.10)

(350)

NP befor Tax

8610

TAX ( 40%)

(3444)

NP after TAX

5166

Cash Dividend (45:55)

2325

Addition to retained earnings (55:45)

2841

Pro forma balance sheet as of 31 December 20XX+1

Assets

Cash (1080*2)

2160

Marketable securities(500*2)

1000

Account receivable (6480*1.15)

7452

Inventory (9000*1.15)

10350

Net fixed assets (12600*1.15)

14490

Total Assets

35452

Liabilities

Retained earnings (12860+2841)

15701

Accounts payable

4320

Taxes payable

180

Notes payable (5300*1.15)

6095

Non-current debt

3500

Shares

3500

External financing needed

2156

Total Liabilities & Equity

35452


Related Solutions

Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet...
Financial Statements: Develop an Income Statement for 20XX, Cash Flow Statement for 20XX, and Balance Sheet as of the end of 20XX based on the data provided below for year 20XX. All sales are collected when the sale is made and all expenses are paid when the expense is incurred. Explain the purpose of each financial statement. a. Income Statement Data for 20XX:  Units produced and sold = 420  Sales ($80 per unit selling price) = $33600 ...
prepare the financial statements of the Company: A) Statement of Comprehensive Income B) Statement of Financial...
prepare the financial statements of the Company: A) Statement of Comprehensive Income B) Statement of Financial Position C) Statement of Changes in Owner's Equity Accounts Payable               63,200.00 Accounts Receivable               74,100.00 Accrued Expenses               20,300.00 Accrued Income                 5,000.00 Accumulated Depreciation - Equipment               20,000.00 Accumulated Depreciation - Furniture               10,000.00 Bonds Payable         1,500,000.00 Capital             517,685.00 Cash in Bank             280,000.00 Cash on Hand               35,000.00 Depreciation Expense - Furniture                     500.00 Depreciation Expense - Equipment                ...
Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information...
Red Queen Restaurants wishes to prepare financial plans. Use the financial statements and the other information provided below to prepare the financial plans. Red Queen Restaurants Income Statement for the Year Ended December 31, 2019   Sales revenue    $799,000 Less: Cost of goods sold   599,000 Gross profits    $200,000 Less: Operating expenses   101,000 Net profits before taxes    $99,000 Less: Taxes (21%)   20,790 Net profits after taxes    $78,210 Less: Cash dividends   20,500 To retained earnings    $57,710       Red...
Prepare a pro forma income statement and balance sheet for the 'coming year' for Netflix (NFLX)
Prepare a pro forma income statement and balance sheet for the 'coming year' for Netflix (NFLX)
Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings for the year ended December 31, 20XX
Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings for the year ended December 31, 20XX and Comparative Balance Sheets for 20XW and 20XX of Maris Corporation: Maris CorporationIncome StatementYear Ended December 31, 20XX  Sales$3,800,000  Cost of goods sold2,250,000        Gross profits1,550,000  Selling and administrative expense540,000  Amortization expense200,000        Operating income810,000  Interest expense43,000        Earnings before taxes767,000  Taxes440,000        Earnings after taxes327,000    Preferred stock dividends30,000     Earnings available to common shareholders$297,000    Shares outstanding198,000  Earnings per share$1.50   Statement of...
Prepare an income statement for the year
The adjusted trial balance of Wilder Company at December 31,2017,includes the following accounts: Owner's Capital $15,600 Owner's Drawings 7,000 Service Revenue 39,000 Salaries & Wages Expense 16,000 Insurance Expense 2,000 Rent Expense 4,000 Supplies Expense 1,500 Depreciation Expense 1,300 Prepare an income statement for the Year
Use the following financial statements and additional information to prepare a statement of cash flows for...
Use the following financial statements and additional information to prepare a statement of cash flows for the year ended December 31, 2018 using the indirect method. Monterey Company Balance Sheets At December 31 2018 2017 Assets:   Cash $85,600 $65,200   Accounts receivable, net 72,850 56,750   Merchandise inventory 157,750 144,850   Prepaid expenses 6,080 12,680   Equipment 280,600 245,600   Accumulated depreciation-Equipment (80,600) (97,600) Total assets $522,280 $427,480 Liabilities:   Accounts payable $52,850 $45,450   Income taxes payable 15,240 12,240   Notes payable (long term)    59,200    79,200 Total...
The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement:...
The comparative financial statements for Prince Company are below:      Year 2 Year 1 Income statement: Sales revenue $ 194,000 $ 168,000 Cost of goods sold 113,000 100,400 Gross profit 81,000 67,600 Operating expenses and interest expense 56,400 53,200 Pretax income 24,600 14,400 Income tax 8,400 4,200 Net income $ 16,200 $ 10,200 Balance sheet: Cash $ 4,400 $ 7,200 Accounts receivable (net) 14,200 18,200 Inventory 40,400 34,200 Property and equipment (net) 45,600 38,400 Total assets $ 104,600 $ 98,000...
Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings...
Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings for the year ended December 31, 20XX and Comparative Balance Sheets for 20XW and 20XX of Maris Corporation: Maris Corporation Income Statement Year Ended December 31, 20XX   Sales $3,400,000   Cost of goods sold 1,950,000         Gross profits 1,450,000   Selling and administrative expense 600,000   Amortization expense 200,000         Operating income 650,000   Interest expense 50,000         Earnings before taxes 600,000   Taxes 400,000         Earnings after taxes...
Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings...
Given is the Income Statement for the year ended December 31, 20XX, Statement of Retained Earnings for the year ended December 31, 20XX and Comparative Balance Sheets for 20XW and 20XX of Maris Corporation: Maris Corporation Income Statement Year Ended December 31, 20XX   Sales $5,400,000   Cost of goods sold 3,650,000         Gross profits 1,750,000   Selling and administrative expense 700,000   Amortization expense 220,000         Operating income 830,000   Interest expense 59,000         Earnings before taxes 771,000   Taxes 460,000         Earnings after taxes...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT