Felton Farm Supplies, Inc. has an ROA (return on assets) of 12 percent, total assets of $300,000 and a net
a. net sales, cost of goods sold, retained earnings b. net sales, inventories, notes payable c. net sales, depreciation expense, advertising expense d. cash, depreciation expense, taxes e. cash, accounts receivable, inventories
6. Which of the following would directly affect (either increase or decrease) net cash flow from operating activities (assuming all else remains constant)? Note: there more be more than one answer for this questions
– record the letter of all that apply (this is an all or nothing answer).
a. An increase in dividends paid. b. A decrease in accounts receivable. c. A decrease in notes payable (i.e., bank loans). d. An increase in inventory. e. An increase in accounts payable. f. An increase in retained earnings. g. A decrease in cash. h. An increase in accruals. i. A decrease in gross plant and equipment.
7. If a firm increases its total assets but its debt ratio, net profit margin and net sales (i.e., revenue) remain the same as they were before total assets decreased, the firm’s:
a. ROE would not change. b. ROE could either increase or decrease depending on the interaction between the equity multiplier and
the days payable ratio.
c. ROE would increase. d. ROE would decrease. e. There is insufficient information to determine the effect on ROE.
8. Which of the following steps is most likely to decrease a company’s cash conversion cycle (assume that none of the following actions has any impact on sales or COGS)? Note: there more be more than one answer for
this questions – record the letter of all that apply (this is an all or nothing answer).
a. Change its receivables policy from net 35 to net 40 (note that this action will increase the firm’s average collection period from 35 days to 40 days).
b. Change its payables policy to pay bills in 40 days instead of in 30 days. c. Decrease the inventory conversion period from 50 days to 40 days. d. Reduce the firm’s notes payable (i.e., bank loan) balance by 20%. e. None of the actions listed above will decrease the firm’s cash conversion cycle.
9. Which of the following actions would decrease the current ratio (assuming an initial current ratio of 0.8, and current liabilities equal to $1,000,000)?
a. Borrow $100,000 in short term debt and deposit this money (i.e., $100,000) into the firm’s cash account. b. Borrow $200,000 in long-term debt to buy $200,000 worth of additional inventory. c. Borrow $50,000 of short-term debt and use the proceeds to pay all operating expenses sooner, thus
lowering accruals (i.e., accrued expenses) by $50,000.
d. Sell $250,000 of fixed assets to pay off an equal amount of long-term debt. e. None of the above – that is, none of the actions listed about will decrease the current ratio.
10. RedCap Manufacturing, Inc. is planning to borrow money by taking out a short term loan (i.e., increase notes payable) and depositing this money directly into the firm’s checking account (i.e., increase cash). RedCap
believes that this event will have no affect on either sales or costs, and therefore no affect on net income.
All else constant, this new policy should cause the firm’s quick ratio (assuming an initial quick ratio of 1.5)
to:
a. Decrease b. Increase c. No Change d. Not enough information is provided to answer this question.
11. BlueHat, Inc. is planning to use excess cash that the company has in its checking account (i.e., reduce cash) to pay off a long term loan balance. (i.e., decrease long-term debt). BlueHat believes that this event will have
no affect on either sales or costs, and therefore no affect on net income.
All else constant, this new policy should cause the firm’s debt ratio (assuming an initial debt ratio of 45%)
to:
a. Decrease b. Increase c. No Change d. Not enough information is provided to answer this question.
12. GreenChapeau, Inc. is planning to increase its short-term loans (i.e., increase notes payable) to pay for an increase in the firm’s basic inventory level (i.e., increase inventory). GreenChapeau believes that this event
will have no affect on either sales or costs, and therefore no affect on net income.
All else constant, this new policy should cause the firm’s current ratio (assuming a current ratio of 1.5) to:
a. Decrease b. Increase c. No Change d. Not enough information is provided to answer this question.
All of the following questions are open-ended problems. You must compute an answer for every problem.
For percentage answers, calculate your answer as a percent rounded to 2 decimal places. For example, you
would record ROA = .1263974 as 12.64% (note that on D2L you will enter 12.64 without the percent sign).
For dollar answers, round to the nearest dollar. For example, you would record $12,345.83943 as $12,346
(note that on D2L you will enter 12346 without a comma and without the dollar sign).
13. Felton Farm Supplies, Inc. has an ROA (return on assets) of 12 percent, total assets of $300,000 and a net profit margin of 4.5 percent. What are Felton Farm Supplies annual sales?
14. Krisle and Kringle's debt-to-total assets ratio is 0.445 (i.e., debt ratio = 44.5%). What is the company’s debt- to-equity ratio? (Enter answer as a ratio rounded to 2 decimal places – that is, do not convert to a percent; for
example, enter 80/35 = 2.2857 as 2.29).
15. Philips, Inc has a debt ratio of 15% and ROE = 13%. What is Phillips’ ROA? (Enter answer as a percent).
16. A firm has an ROA of 17% and a debt/equity ratio of 0.65. The firm's ROE is _________. (Enter answer as a percent).
17. Assume that XYZ, Inc. has:
Debt ratio = 60%
Net profit margin = 12.5%
Return on assets (ROA) = 15%
Find XYZ’s Total Asset Turnover ratio. (Enter answer as a ratio – that is, do not convert to a percent).
18. Assume that your firm has ROA of 17.5%, ROE of 38% and Total Asset Turnover ratio of 2.75. Calculate the debt ratio for the firm. (Enter answer as a percent).
USE THE DATA IN THE TABLE BELOW TO ANSWER QUESTIONS 19 – 24
(Assume all account figures are in dollars)
19. This company’s gross profit margin (as a percent rounded to 1 decimal place) in 2014 was ________.
20. Assume that this is a retail company. If the company purchased products that it sold in 2015 for $5.00 per unit, how many units did the company purchase in 2015?
21. ROE for 2015 is _____%.
22. Cash flow from operating activities in 2015 is $ _______.
23. Cash flow from investing activities in 2015 is $ _________.
24. Cash flow from financing activities in 2015 is $ _________.
USE THE INFORMATION BELOW TO ANSWER THE FOLLOWING 3 QUESTIONS
2014 2015
Accounts payable 440 380
Accounts receivable, net 1,810 2,040
Accruals 95 120
Cash 120 90
Common stock 2,120 2,380
Cost of goods sold 6,610 6,420
Depreciation expense 1,560 1,630
Interest expense 140 170
Inventory (end of year) 5,720 5,530
Long-term debt 3,890 4,150
Net fixed assets 7,530 8,050
Net sales 10,750 11,650
Notes payable 800 740
Operating expenses (excluding depreciation) 1,680 1,780
Retained earnings 7,835 7,940
Taxes 260 380
25. Calculate the Cash flows from operating activities for 2011.
26. Calculate the Cash flows from investing activities for 2011.
27. Calculate the Cash flows from financing activities for 2011.
2010 2011
Cash 1,500 1,820
Account receivable 3,740 3,980
Inventory 10,120 8,470
Total current assets 15,360 14,270
Gross fixed assets 56,100 63,840
(Accumulated depreciation) (9,590) (11,000)
Net fixed assets 46,510 52,840
Total assets 61,870 67,110
Notes payable 1,000 1,000
Accounts payable 2,260 4,150
Accruals 1,570 1,640
Current portion of LT debt 470 1,730
Total current liabilities 5,300 8,520
Lont-term debt 37,750 34,790
Common stock 1,000 1,500
Paid in capital 4,800 9,460
Retained earnings 13,020 12,840
Total liabilities and equity 61,870 67,110
Additional Data from 2011 Income Statement:
Sales in 2011 238,000
Net income in 2011 9,940
Mellon Company
Balance Sheet
For the Years Ending December 31, 2010 and 2011
(All figures in dollars)
USE THE FOLLOWING INFORMATION TO CONSTRUCT A BALANCE SHEET
TO ANSWER QUESTIONS 28 through 30
Assume that the only accounts on the balance sheet are those listed below. Fill in this chart with the data provided
and then answer questions 28, 29 and 30.
Cash ____________ Notes payable ____________
Accounts receivable ____________ Accounts payable ____________
Inventory ____________ Long-term debt ____________
Gross fixed assets ____________ Equity ____________
(Accumulated depreciation) ____________ Total liab & equity ____________
Net fixed assets ____________
Total assets ____________
28. Cash = ____________.
29. Long-term debt = ____________.
30. Total assets =____________.
Sales 2,000,000$
Gross profit margin 20%
Inventory turnover ratio (Cost of goods sold/Inventory) 25
Net profit margin 4%
Average collection period 45
Return on equity 25%
Accumulated depreciation 75,000$
Return on assets 12.5%
Accounts payable days 18
Notes payable 18,000$
Gross fixed assets 400,000$
Percent of sales on credit (remainder are cash sales) 80%
NOTE: Assume a 360 day year for all ratios, etc.
USE THE FOLLOWING INFORMATION TO FILL IN THE BALANCE SHEET BELOW
TO ANSWER QUESTIONS 31 through 34
Note: Of total sales, 60 percent are on credit and the remainder are cash sales. Assume a 360-day year. All
data in the table above, unless otherwise stated, is for the year 2015.
Hodun, Inc.
Balance Sheet for the Year Ending December 31, 2015
Cash __________ Notes payable __________
Accounts receivable __________ Accounts payable __________
Inventory __________ Accruals __________
Net fixed assets __________ Long-term debt __________
Total assets __________ Common stock ($2 par value) __________
Capital surplus __________
Retained earnings __________
Total liab. & equity __________
31. Cash = ____________.
32. Long-term debt = ____________.
33. Total assets =____________.
34. Capital surplus = __________.
Number of shares outstanding 15,000 Average collection period (days) 60
Sales 200,000$ Accounts payable days 90
Gross profit margin 20% Retained earnings (2010) 23,700$
Inventory turnover ratio 4 Dividend payout ratio 80%
Notes payable 8,000$ Accruals 4,000$
Net profit margin 15% Current ratio 1.5
Return on assets 8% Debt ratio 40%
USE THE FOLLOWING DATA TO ANSWER QUESTIONS 35 – 40
35. Net fixed assets in 2014 were $__________.
36. COGS on the 2013 common-sized income statement was 24%. Therefore, COGS in 2013 was
37. The debt ratio for 2014 was ____%.
38. Cash flow from operations in 2014 was $________.
39. Cash flow from investing in 2014 was $__________.
40. Total dividends paid in 2014 was $_______.
2013 2014
Sales 500,000 560,000
COGS ???? 149,350
Gross profit 380,000 410,650
Oper. exp 225,000 250,100
Depreciation 15,000 15,000
Operating profit 140,000 145,550
Interest exp. 5,000 5,000
EBT 135,000 140,550
Taxes 50,000 56,000
Net Income 85,000 84,550
2013 2014
Cash 450,000 478,500
Accounts rec 275,000 250,000
Inventories 280,000 325,000
Current Assets 1,005,000 1,053,500
Net fixed assets 1,125,000 ???
Total Assets 2,130,000 2,293,500
Notes payable 150,000 125,000
Accounts payable 90,000 115,000
Accruals 15,000 25,000
Current Liabilities 255,000 265,000
Long-term debt 1,000,000 1,050,000
Common stock @ ($0.25 par) 25,000 28,500
Additional paid in capital 500,000 570,000
Retained earnings 350,000 380,000
Total Liabilities & Equity 2,130,000 2,293,500
Annual Balance Sheets
Annual Income Statements