Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

2. Using 2003 as the base year, compute an index-number trend series for: - Sales - Cost of goods sold - Gross profit - Marketing

2. Using 2003 as the base year, compute an index-number trend series for:

- Sales

- Cost of goods sold

- Gross profit

- Marketing and administrative costs.

- Net Income

image text in transcribed

C D E F . B Balance Sheet Income Statement 2005 2004 2003 2004 Assets Cash Accounts receivable, net nventory Other current assets Plant and equipment, net Total assets 12,000 183,000 142,000 5,000 160,000 502,000 14,000 80,000 97,000 6,000 110,000 307,000 17,000 60,000 52,000 4,000 70,000 203,000 Net Sales Cost of goods sold Gross profit Marketing and administrative costs Operating Income Interest cost Income before income tax Income tax 2005 1,680,000 923,000 757,000 670,000 87,000 12,000 75,000 30,000 45,000 1,245,000 805,000 440,000 396,700 43,300 7,300 36,000 14,400 21,600 2003 1,050,000 512,000 538,000 467,760 70,240 2,240 68,000 28,000 40,000 Net Income Liabilities and Equity Accounts payable Federal income tax payable Long-term liabilities Common stock, $5 par value Retained earnings Total liabilities and equity 147,800 30,000 120,000 110,000 94,200 502,000 49,400 14,400 73,000 110,000 60,200 307,000 23,000 28,000 22,400 80,000 49,600 203,000 Statement of Retained Earnings Balance, beginning Add: Net income Subtotal Deduct: Dividends paid Balance, ending 2005 60,200 45,000 105,200 11,000 94,200 2004 49,600 21,600 71,200 11,000 60,200 nancials Q1-Q3 + C D E F . B Balance Sheet Income Statement 2005 2004 2003 2004 Assets Cash Accounts receivable, net nventory Other current assets Plant and equipment, net Total assets 12,000 183,000 142,000 5,000 160,000 502,000 14,000 80,000 97,000 6,000 110,000 307,000 17,000 60,000 52,000 4,000 70,000 203,000 Net Sales Cost of goods sold Gross profit Marketing and administrative costs Operating Income Interest cost Income before income tax Income tax 2005 1,680,000 923,000 757,000 670,000 87,000 12,000 75,000 30,000 45,000 1,245,000 805,000 440,000 396,700 43,300 7,300 36,000 14,400 21,600 2003 1,050,000 512,000 538,000 467,760 70,240 2,240 68,000 28,000 40,000 Net Income Liabilities and Equity Accounts payable Federal income tax payable Long-term liabilities Common stock, $5 par value Retained earnings Total liabilities and equity 147,800 30,000 120,000 110,000 94,200 502,000 49,400 14,400 73,000 110,000 60,200 307,000 23,000 28,000 22,400 80,000 49,600 203,000 Statement of Retained Earnings Balance, beginning Add: Net income Subtotal Deduct: Dividends paid Balance, ending 2005 60,200 45,000 105,200 11,000 94,200 2004 49,600 21,600 71,200 11,000 60,200 nancials Q1-Q3 +

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Managerial Decision Modeling With Spreadsheets

Authors: Nagraj Balakrishnan, Barry Render, Jr. Ralph M. Stair

3rd Edition

136115837, 978-0136115830

Students also viewed these Finance questions