BA62072 Campbellsville University Week 1 Basic Financial Statements Probems

User Generated

fnaznynivwnl4

Business Finance

BA62072

Campbellsville University

Description

BA 620 Managerial Finance

Group Problem Set 1: This problem Set is based on materials covered in module 1/week 1. It is designed for you to demonstrate your understanding of basic financial statements, financial statement analysis, break-even concepts, financial and operating leverages. Before you start this assignment, please review weeks 1 and 2 materials thoroughly.

Finance date of Adams Stores, Inc. for the year ending 2016 and 2017.

Items

2016

2017

Sales

$3,432,000

$5,834,400

Cash

9,000

7,282

Other Expenses

340,000

720,000

Retained Earnings

203,768

97,632

Long-term debt

323,432

1,000,000

Cost of goods sold

2,864,000

4,980,000

Depreciation

18,900

116,960

Short-term investments

48,600

20,000

Fixed Assets

491,000

1,202,950

Interest Expenses

62,500

176,000

Shares outstanding (par value

= $4.60)

100,000

100,000

Market Price of stock

8.50

6

Accounts Receivable

351,200

632,160

Accounts payable

145,600

324,000

Inventory

715,200

1,287,360

Notes Payable

200,000

720,000

Accumulated Depreciation

146,200

263,160

Accruals

136,000

284,960

Tax Rate

40%

40%

Instructions:

As a group, complete the following activities using the financial information above:

Part 1: Financial Statements

  • Prepare the income statement for 2016 and 2017. Include statement of retained earnings for 2017
  • Prepare the balance sheet for 2016 and 2017
  • Prepare Common-Size financial statements of income statement and balance sheet.
  • Prepare Statement of Cash Flows

Part 2: Financial Statement Analysis

  • Based on your financial statements (from Part 1), calculate the following ratios for the two years. Show all your calculations in good form. Show your formulas. If you use excel, each calculation need to show the excel formula

Current ratio

Quick ratio

Inventory turnover (times)

Average collection period (days)

Total asset turnover (times)

Debt ratio

Times interest earned

Gross profit margin

Net profit margin

Return on total assets

Return on equity

P/E ratio

Return on equity using DuPont Analysis

  • Comments on the ratios by comparing 2016 to 2017 ratios.
  • Assume Adams Stores, Inc. is a retail company similar to WalMart, Myers, or Target. Compare 2017 ratios to the industry average. Please note that Adams Stores, Inc. is not a real company. To find comparable industry ratios, you need to search for industry ratios for retail. See information on Moodle for instructions on how to find industry ratios. Based on the industry average, how is Adams Stores, Inc. doing financially?

Part 3: Break-even, Financial and Operating Leverages

Johnson Products, Inc.

Income Statement

For the Year Ended December 31, 2018

Sales (40,000 bags at $50 each) ..................................

$2,000,000

Less: Variable costs (40,000 bags at $25) ................

1,000,000

Fixed costs ..............................................................

600,000

Earnings before interest and taxes ..............................

400,000

Interest expense ...........................................................

120,000

Earnings before taxes .................................................

280,000

Income tax expense (20%) ..........................................

56,000

Net income ..................................................................

$ 224,000

Based on the information above, calculate (show all calculations and responses in good form):

  • Break-even in units (in dollars and units). Explain what your numbers mean. As a manager, how would you use the numbers in financial planning?
  • What is the degree of financial leverage? Explain what your number mean. As a manager, how would you use the numbers in financial planning?
  • What is the degree of operating leverage? Explain what your number mean. As a manager, how would you use the numbers in financial planning?

Specific Instructions:

  • You may use Excel or Word. Please DO NOT use any other format such PDF, etc.

Unformatted Attachment Preview

BA 620 Managerial Finance Group Problem Set 1: This problem Set is based on materials covered in module 1/week 1. It is designed for you to demonstrate your understanding of basic financial statements, financial statement analysis, break-even concepts, financial and operating leverages. Before you start this assignment, please review weeks 1 and 2 materials thoroughly. Finance date of Adams Stores, Inc. for the year ending 2016 and 2017. Items Sales Cash Other Expenses Retained Earnings Long-term debt Cost of goods sold Depreciation Short-term investments Fixed Assets Interest Expenses Shares outstanding (par value = $4.60) Market Price of stock Accounts Receivable Accounts payable Inventory Notes Payable Accumulated Depreciation Accruals Tax Rate 2016 $3,432,000 9,000 340,000 203,768 323,432 2,864,000 18,900 48,600 491,000 62,500 2017 $5,834,400 7,282 720,000 97,632 1,000,000 4,980,000 116,960 20,000 1,202,950 176,000 100,000 8.50 351,200 145,600 715,200 200,000 146,200 136,000 40% 100,000 6 632,160 324,000 1,287,360 720,000 263,160 284,960 40% Instructions: As a group, complete the following activities using the financial information above: Part 1: Financial Statements A. Prepare the income statement for 2016 and 2017. Include statement of retained earnings for 2017 B. Prepare the balance sheet for 2016 and 2017 C. Prepare Common-Size financial statements of income statement and balance sheet. D. Prepare Statement of Cash Flows Part 2: Financial Statement Analysis A. Based on your financial statements (from Part 1), calculate the following ratios for the two years. Show all your calculations in good form. Show your formulas. If you use excel, each calculation need to show the excel formula Current ratio Quick ratio Inventory turnover (times) Average collection period (days) Total asset turnover (times) Debt ratio Times interest earned Gross profit margin Net profit margin Return on total assets Return on equity P/E ratio Return on equity using DuPont Analysis B. Comments on the ratios by comparing 2016 to 2017 ratios. C. Assume Adams Stores, Inc. is a retail company similar to WalMart, Myers, or Target. Compare 2017 ratios to the industry average. Please note that Adams Stores, Inc. is not a real company. To find comparable industry ratios, you need to search for industry ratios for retail. See information on Moodle for instructions on how to find industry ratios. Based on the industry average, how is Adams Stores, Inc. doing financially? Part 3: Break-even, Financial and Operating Leverages Johnson Products, Inc. Income Statement For the Year Ended December 31, 2018 Sales (40,000 bags at $50 each) .................................. Less: Variable costs (40,000 bags at $25) ................ Fixed costs .............................................................. Earnings before interest and taxes .............................. Interest expense ........................................................... Earnings before taxes ................................................. Income tax expense (20%) .......................................... Net income .................................................................. $2,000,000 1,000,000 600,000 400,000 120,000 280,000 56,000 $ 224,000 Based on the information above, calculate (show all calculations and responses in good form): a. Break-even in units (in dollars and units). Explain what your numbers mean. As a manager, how would you use the numbers in financial planning? b. What is the degree of financial leverage? Explain what your number mean. As a manager, how would you use the numbers in financial planning? c. What is the degree of operating leverage? Explain what your number mean. As a manager, how would you use the numbers in financial planning? Specific Instructions: 1. You may use Excel or Word. Please DO NOT use any other format such PDF, etc.
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Attached.

Group Problem Set 1 : Financial Statements
Part 1: Income Statements
A Adams Stores Inc.
Income Statements
For the Financial Years Ending 2016 and 2017

Sales
Cost of goods sold
Gross Income

2016
$
3.234.000,00
(2.864.000,00)
370.000,00

2017
$
5.834.400,00
(4.980.000,00)
854.400,00

Other Expenses
Interest Expense
Depreciation Expense
Total Expenses

340.000,00
62.500,00
18.900,00
421.400,00

Income before Taxes
Tax Provision
Net income

(51.400,00)
20.560,00
(71.960,00)

(158.560,00)
63.424,00
(221.984,00)

Add: Other Income

275.728,00

116.000,00

:Retained Income b/f
Retained Income c/f

720.000,00
176.000,00
116.960,00
1.012.960,00

203.768,00
203.768,00

97.784,00

2016
$
325.900,00

2017
$
822.830,00

325.900,00

822.830,00

9.000,00
48.600,00
351.200,00
715.200,00
1.124.000,00

7.282,00
20.000,00
632.160,00
1.287.360,00
1.946.802,00

B Adams Stores Inc.
Balance Sheet
As at Years Ended 2016 and 2017

Fixed Assets

Current Assets
Cash
Short term investments
Accounts Receivable
Inventories
Total

Total Assets
Liabilities
Long term Debt
Current Liabilities
Accounts Payable
Notes Payable
Accruals
Tax Provision

Total Liabilities

Equity
Retained Income c/f
Shares Outstanding
Total Equity and Liabilities

1.449.900,00

2.769.632,00

323.432,00

1.000.000,00

145.600,00
200.000,00
136.000,00
20.560,00
502.160,00

324.000,00
720.000,00
284.960,00
63.424,00
1.392.384...


Anonymous
Just the thing I needed, saved me a lot of time.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags