Business, 29.06.2021 17:10, alyssamaize

This problem Set is based on materials covered in modules 1 and 2. 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 Modules 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 = $46.00)
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
A. Prepare the income statement for 2016 and 2017. Include statement of retained earnings for 2017. The company paid $11,000 dividend in 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?

Answers: 1

Show answers

Other questions on the subject: Business

Business, 21.06.2019 23:30, gwendallinesikes

Select the correct answer. the word intestate means that a person has died with or without a will?

Answers: 1

continue

Business, 22.06.2019 01:00, avablankenship

Data pertaining to the current position of forte company are as follows: cash $437,500 marketable securities 170,000 accounts and notes receivable (net) 320,000 inventories 700,000 prepaid expenses 42,000 accounts payable 240,000 notes payable (short-term) 250,000 accrued expenses 310,000 required: 1. compute (a) the working capital, (b) the current ratio, and (c) the quick ratio. round ratios to one decimal place. 2. compute the working capital, the current ratio, and the quick ratio after each of the following transactions, and record the results in the appropriate columns of the table provided. consider each transaction separately and assume that only that transaction affects the data given. round to one decimal place. a. sold marketable securities at no gain or loss, 75,000. b. paid accounts payable, 135,000. c. purchased goods on account, 100,000. d. paid notes payable, 105,000. e. declared a cash dividend, 125,000. f. declared a common stock dividend on common stock, 45,000. g. borrowed cash from bank on a long-term note, 205,000. h. received cash on account, 130,000. i. issued additional shares of stock for cash, 635,000. j. paid cash for prepaid expenses, 15,000.

Answers: 3

continue

Business, 22.06.2019 09:40, cerna

Alpha industries is considering a project with an initial cost of $8 million. the project will produce cash inflows of $1.49 million per year for 8 years. the project has the same risk as the firm. the firm has a pretax cost of debt of 5.61 percent and a cost of equity of 11.27 percent. the debt–equity ratio is .60 and the tax rate is 35 percent. what is the net present value of the project?

Answers: 1

continue

Business, 22.06.2019 20:00, Haddixhouse8948

How many organs are supplied at a zero price? (b) how many people die in the government-regulated economy where the government-set price ceiling is p = 0? the quantity qd – qa. the quantity qe – qa. the quantity qd – qe. (c) how many people die in the market-driven economy?

Answers: 1

continue

Do you know the correct answer?

This problem Set is based on materials covered in modules 1 and 2. It is designed for you to demonst...