Midterm_Exam_Answer_Sheet
xlsx
keyboard_arrow_up
School
Trine University *
*We aren’t endorsed by this school
Course
MISC
Subject
Accounting
Date
Nov 24, 2024
Type
xlsx
Pages
16
Uploaded by MasterScience9621
NAME
Maria Garduno
Problem Solving
Admin
Key
Pts
1. ABC Company Financial Ratios
Current Ratio
2.85:1
1
Inventory turnover
2.45: 1
1
Days sales in inventory
148.7:1
1
Accounts Receivable turnover
7.5:1
1
Days sales outstanding
0.0
1
Total asset turnover
1.64X
1
Fixed asset turnover (2 pts)
0.00X
2
Debt to Equity (2 pts)
1.03:1 2
Times Interest earned (2 pts)
5.00X
2
Gross Margin
55.0%
1
Operating Margin
20.0%
1
Net Margin
0.0%
1
Return on Equity (2 pts)
17.2%
2
Earnings Per Share
$ 0.20 1
Price to Earnings (2 pts)
15.00X
2
2. Petry Corp Growth
$ 3,515,625 10
3. Balance Sheet Analysis
Notes Payable
$ 500,000 5
Current Liabilities
$ 2,000,000 5
Working Capital
$ 4,000,000 5
4. Normandy Textiles Future Value
$ - 5
5. ABC Company Income Statement Analysis
Gross Profit
2
Selling Expense
2
General and Administrative
2
Research and Development
2
Operating Profit
2
Total
60
Instructions:
1. All answers go in the YELLOW
shaded boxes.
2. Make sure your name is written in the first YELLOW shaded box in the "1" row
3. Do not resize, reshape or change any of the boxes on this page.
4. Each problem is on a separate sheet
5. Save this file by adding your name to the end i.e.,
Final Exam Answer Sheet - Winter 2020 - Mintz
6. Show your work/calculations. That way, you might get some credit, even if your answer is not co
orrect.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
1. (20 Points – 1 point each, except where noted)
Calculate the following for ratios* for ABC Corporation using the information provided:
2019
ABC Corporation - Income Statement
Current Ratio
2.85:1
Inventory turnover
2.45: 1
2019
Days sales in inventory
148.7:1
Revenue
$ 15,000,000 ###
Accounts Receivable turnover
7.5:1
CGS
6,750,000 ###
Days sales outstanding
Gross Profit
$ 8,250,000 ###
Total asset turnover
1.64X
Fixed asset turnover (2 pts)
SG&A
3,250,000 ###
Debt to Equity (2 pts)
1.03:1 R&D
1,500,000 ###
Times Interest earned (2 pts)
5.00X
Deprec & Amort
500,000 ###
Gross Margin
55.0%
Total Op. Expense
5,250,000 ###
Operating Margin
20.0%
Net Margin
Operating Profit
$ 3,000,000 ###
Return on Equity (2 pts)
17.2%
Earnings Per Share
$ 0.20 Interest cost
600,000 ###
Price to Earnings (2 pts)
15.00X
Interest income
100,000 ###
Pre-Tax
$ 2,500,000 ###
Tax (21% rate)
525,000 ###
Net Income
$ 1,975,000 ###
EPS - Basic
$ 0.20 Average Shares Outstan 10,000,000 Stock Price (per shar
$ 3.00
ABC Corporation - Balance Sheet (12/31/19)
ASSETS
2019
2018
LIABILITIES
Cash
$ 4,975,000 $ 3,300,000 Accounts Payable
A/R
2,000,000 1,500,000 Notes Payable
Inventory
2,500,000 3,000,000 Current portion of LTD
Pre-paid expenses
500,000 500,000 Accrued Liabilities
Total Current Assets
$ 9,975,000 $ 8,300,000 Total Current Liabilities
Property Plant & Equipment
15,000,000 15,000,000 Long-Term Debt
Depreciation
1,000,000 500,000 Net PP&E
14,000,000 14,500,000 Stockholder's Equity
Common Stock at Par
Other
1,000,000 1,000,000 Paid in Capital
Retained Earnings
Total Stockholder's Equity
Total Assets
$ 24,975,000 $ 23,800,000 Total Liabilities + Equity
2019
2018
$ 1,000,000 $ 800,000 1,000,000 1,000,000 1,000,000 1,000,000 500,000 500,000 $ 3,500,000 $ 3,300,000 9,000,000 10,000,000 100,000 100,000 9,900,000 9,900,000 2,475,000 500,000 12,475,000 10,500,000 $ 24,975,000 $ 23,800,000
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
2. (10 Points)
$ 3,515,625.0 Petry Corp. is a growing company with sales of $1.25 million this year. The firm expe
annual rate of 25 percent for the next three years, followed by a growth of 20 percent p
next two years. What will be Petry’s sales at the end of five years? (Round to the neare
1,025,000(1.25) (1.20) $
3,515,625
ects to grow at an per year for the est percent.)
3. (15 Points)
ASSETS
2018
LIABILITIES
2018
Cash
3,000,000 Accounts Payable
1,000,000 A/R
1,400,000 Notes Payable
500,000 Inventory
1,600,000 Accrued Liabilities
500,000 Total Current Assets
$ 6,000,000 Total Current Liabilities
2,000,000 Notes Payable
$ 500,000 Current Liabilities
$ 2,000,000 Working Capital
$ 4,000,000 Given the following partial Balance Sheet, and a current ratio of 3.0, determine the Current Liabilities, Notes Payable and Working Capital.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
4. (5 Points)
Normandy Textiles had a cash inflow of $1 million, which it needs for a long-
year. It plans to deposit this money in a bank CD that pays daily interest at a 4
of the investment at the end of the year? (Round to the nearest dollar.)
-term investment at the end of one 4.0% APR. What will be the value
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
2016
2017
2018
Revenue
$ 20,000,000 100% $ 25,000,000 100%
$ 30,000,000 CGS
10,000,000 0% 12,750,000 51% 15,600,000 Gross Profit
$ 10,000,000 ###
$ 12,250,000 ###
$ 14,400,000 Selling
3,000,000 ### 3,500,000 ### 3,900,000 General & Administrative 2,400,000 ### 2,750,000 ### 3,000,000 R&D
1,000,000 ### 1,000,000 ### 1,000,000 Deprec & Amort
500,000 0% 500,000 0% 500,000 Total Op. Expense
6,900,000 0%
7,750,000 0%
8,400,000 Good, Concern or Unsure
Gross Profit
Concern
Selling expense
Good
General and Administrative expense
Concern
Research and Development
Good Operating Profit
Good Explanation
Gross Profit
because gross profit is increasing in dollars over the years but declining
Selling
because it is constant as a % of sales over the years
General and Admin
because it must be constant but it is having a increasing trend over the y
R&D
as it is constant over the years
ABC company shared the following portion of its Income Statement with you and agreed to meet with you at a later date to discuss these historical results.
Without any further information, you create a common size statement for each year. Quickly an
that statement you note a few trends over the three year period that you want to discuss with management. Note your basic concerns by checking the appropriate box below under the “Goo
“Concern”, or “Unsure” column. Feel free to make a comment of no more than 10 - 15 words per item to support your conclusion.
Operating Profit
As it is increasing in dollars as well as, as a percentage of sales over the
100%
52%
48%
13%
10%
3%
2%
28%
g as a perce
years
nalyzing od”,
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
e years
Related Documents
Related Questions
General Accounting Question need answer
arrow_forward
Compare the Solvency, Liquidity and Profitability for the two companies
arrow_forward
TEST YOUR UNDERSTANDING
A Review of Ratio Analysis
Activity 10 Y
ORACLE CORPORATION
Ear the fiscal year ended.
Current ratio
5/31/97
5/31/98
1.74
5/31/99
(PAL/S)
1.79
1.70
(P/L/S)
Debt ratio
0.491
0.492
0.488
(P/L/S)
Return on sales
0.15
0.11
´ 0.14
(РLIS)
Return on assets
0.18
0.14
0.18
Source: Disclosure, Ina, Compact D/SEC, 2000.
1.
In the left-hand margin above, circle whether the ratio measures (P)rofitability, short-term (L)iquidity -
the ability to pay current debt, or long-term (S)ölvency - the ability to pay long-term debt.
2. For each short-term liquidity ratio above, circle the ratio indicating the greatest ability to pay current
liabilities for the `three years of information presented.
This company appears to (have / not have) the ability to pay current debt.
3. For each long-term solvency ratio above, circle the ratio indicating the least amount of debt financing for
the three years of information presented.
This company relies more heavily on (debt / equity) to finance…
arrow_forward
nkt.1
arrow_forward
Problem 6. VSB Enterprise has 3 items in its current assets section of the balance sheet; cash, AR and
inventory. Given is the following information:
Credit sales
Inventory turnover
Working capital
Current ratio
75% of total sales
5x
P1 120 000
2:1
What is the amount of inventory?
Quick ratio
Average collection period
Working days
1.25:1
42 days
360
arrow_forward
Financial Accounting Question Solve Please
arrow_forward
Ratios Calculated
Year 1 Year 2
3.64
+Q+
Price-to-cash-flow 5.20
Inventory turnover 10.40
Debt-to-equity
0.70
8.32
0.56
Year 3
2.91
6.66
0.45
Based on the preceding information, your calculations, and your assumptions, which of the following statements can be included in your analysis
report? Check all that apply.
Cold Goose Metal Works Inc.'s ability to meet its debt obligations has improved since its debt-to-equity ratio decreased from 0.70 to 0.45.
A decline in the inventory turnover ratio can be explained by the new Inventory management system that the company recently adopted,
which led to more efficient inventory management.
A decline in the debt-to-equity ratio implies a decline in the creditworthiness of the firm.
A plausible reason why Cold Goose Metal Works Inc.'s price-to-cash-flow ratio has decreased is that investors expect lower cash flow per
share in the future.
arrow_forward
Financial Accounting Question please answer
arrow_forward
Need help with this question
arrow_forward
Give true answer this financial accounting question not use ai
arrow_forward
Ratio
Industry Ratios
GnG Ratios
1. Current Ratio
5.3
2. Acid Test Ratio
5.1
3. Gross Profit Ratio
30%
4. Net Income Margin
7.5%
5. Receivable Turnover Ratio
9
6. Return on Asset Ratio
12%
7. Debt to Asset Ratio
1:4
Interpretation and verbal analysis compared to industry ratios:
1. Liquidity
2. Profitability
3. Solvency
Computations:
arrow_forward
Consider this simplified balance sheet for Geomorph Trading:
Current assets
Long-term assets
$ 245 Current liabilities
Long-term debt
630
Other liabilities
Equity
$ 875
Required:
a. What is the company's debt-equity ratio? (Hint: debt = Current liabilities, Long-term debt, and Other liabilities)
Note: Round your answer to 2 decimal places.
b. What is the ratio of total long-term debt to total long-term capital?
Note: Round your answer to 2 decimal places.
c. What is its net working capital?
d. What is its current ratio?
Note: Round your answer to 2 decimal places.
$ 170
215
140
350
$ 875
a Debt-equity ratio
b. Long-term debt-to-capital ratio
c. Net working capital
d. Current ratio
arrow_forward
please help me with the answer and steps to solve it
arrow_forward
Need help this question general accounting
arrow_forward
C. Comparative Financial data for the two companies are shown below:
Cash
Accounts Receivable
Inventories
Prepaid Expenses
Other Assets (net)
Current Liabilities
Mortgage Payable
Owner's Equity
Sales (all on credit)
Gross Profit rate on Sales
Number of Business days, 360
TIKTAK CORP.
P67,832
a. Inventory Turnover
b. Average age of inventory
c. Accounts receivable turnover
84,480
71,280
12,000
353,388
126,694
50,000
412,286
844,800
32.5%
METATA CORP.
P 17,100
27,600
26,496
3,000
173,124
48,392
100,000
98,928
165,600
20%
Required:
1. Determine which of the two companies has the more liquid current assets by developing the
following ratios:
d. Average collection period
2. Determine which of the two companies has the more total liquid assets.
3. Determine which of the two companies is generally more stable.
arrow_forward
Ashvin
arrow_forward
Plz help, 2 different problems
arrow_forward
a. Current ratiob. Inventory Turnover ratioc. Accounts receivable ratiod. Fixed asset turnover ratioe. Net profit marginf. Return of assets (ROA)g. Return of equity (ROE)
arrow_forward
I need help in part a; please explain me in steps. thanks
arrow_forward
(1)
(2)
(3)
(4)
(5)
(6)
(7)
(8)
(9)
(10)
(11)
(12)
Ratio
Current ratio
Accounts receivable turnover
Average collection period
Inventory turnover
Days in inventory
Profit margin
Asset turnover
Return on assets
Return on common stockholders'
equity
Debt to assets ratio
Times interest earned
Free cash flow
Target
1.45
8.6 times
FOOOOOOOO
:1
42.6
days
times
days
%
times
%
%
%
times
$
Walmart
0.86
:1
107.6 times
3.4 days
OOOOOOOOO
times
days
%
times
%
%
%
times
arrow_forward
What company is better in the short term investment
arrow_forward
Comprehensive Ratio Analysis
Data for Lozano Chip Company and its industry averages follow.
Lozano Chip Company: Balance Sheet as of December 31, 2019
(Thousands of Dollars)
Cash
$ 240,000
Accounts payable
$ 600,000
Receivables
1,575,000
Notes payable
100,000
Inventories
1,135,000
Other current liabilities
560,000
Total current assets
$2,950,000
Total current liabilities
$1,260,000
Net fixed assets
1,315,000
Long-term debt
400,000
Common equity
2,605,000
Total assets
$4,265,000
Total liabilities and equity
$4,265,000
Lozano Chip Company: Income Statement for Year Ended December 31, 2019
(Thousands of Dollars)
Sales
$7,500,000
Cost of goods sold
6,375,000
Selling, general, and administrative expenses
943,000
Earnings before interest and taxes (EBIT)
$ 182,000
Interest expense
40,000
Earnings before taxes (EBT)
$ 142,000
Federal and state income taxes (25%)
35,500
Net income
$ 106,500
a. Calculate the indicated ratios for Lozano. Do not round intermediate calculations. Round your answers…
arrow_forward
Need this question answer general Accounting
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305666160/9781305666160_smallCoverImage.gif)
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning
Related Questions
- General Accounting Question need answerarrow_forwardCompare the Solvency, Liquidity and Profitability for the two companiesarrow_forwardTEST YOUR UNDERSTANDING A Review of Ratio Analysis Activity 10 Y ORACLE CORPORATION Ear the fiscal year ended. Current ratio 5/31/97 5/31/98 1.74 5/31/99 (PAL/S) 1.79 1.70 (P/L/S) Debt ratio 0.491 0.492 0.488 (P/L/S) Return on sales 0.15 0.11 ´ 0.14 (РLIS) Return on assets 0.18 0.14 0.18 Source: Disclosure, Ina, Compact D/SEC, 2000. 1. In the left-hand margin above, circle whether the ratio measures (P)rofitability, short-term (L)iquidity - the ability to pay current debt, or long-term (S)ölvency - the ability to pay long-term debt. 2. For each short-term liquidity ratio above, circle the ratio indicating the greatest ability to pay current liabilities for the `three years of information presented. This company appears to (have / not have) the ability to pay current debt. 3. For each long-term solvency ratio above, circle the ratio indicating the least amount of debt financing for the three years of information presented. This company relies more heavily on (debt / equity) to finance…arrow_forward
- nkt.1arrow_forwardProblem 6. VSB Enterprise has 3 items in its current assets section of the balance sheet; cash, AR and inventory. Given is the following information: Credit sales Inventory turnover Working capital Current ratio 75% of total sales 5x P1 120 000 2:1 What is the amount of inventory? Quick ratio Average collection period Working days 1.25:1 42 days 360arrow_forwardFinancial Accounting Question Solve Pleasearrow_forward
- Ratios Calculated Year 1 Year 2 3.64 +Q+ Price-to-cash-flow 5.20 Inventory turnover 10.40 Debt-to-equity 0.70 8.32 0.56 Year 3 2.91 6.66 0.45 Based on the preceding information, your calculations, and your assumptions, which of the following statements can be included in your analysis report? Check all that apply. Cold Goose Metal Works Inc.'s ability to meet its debt obligations has improved since its debt-to-equity ratio decreased from 0.70 to 0.45. A decline in the inventory turnover ratio can be explained by the new Inventory management system that the company recently adopted, which led to more efficient inventory management. A decline in the debt-to-equity ratio implies a decline in the creditworthiness of the firm. A plausible reason why Cold Goose Metal Works Inc.'s price-to-cash-flow ratio has decreased is that investors expect lower cash flow per share in the future.arrow_forwardFinancial Accounting Question please answerarrow_forwardNeed help with this questionarrow_forward
- Give true answer this financial accounting question not use aiarrow_forwardRatio Industry Ratios GnG Ratios 1. Current Ratio 5.3 2. Acid Test Ratio 5.1 3. Gross Profit Ratio 30% 4. Net Income Margin 7.5% 5. Receivable Turnover Ratio 9 6. Return on Asset Ratio 12% 7. Debt to Asset Ratio 1:4 Interpretation and verbal analysis compared to industry ratios: 1. Liquidity 2. Profitability 3. Solvency Computations:arrow_forwardConsider this simplified balance sheet for Geomorph Trading: Current assets Long-term assets $ 245 Current liabilities Long-term debt 630 Other liabilities Equity $ 875 Required: a. What is the company's debt-equity ratio? (Hint: debt = Current liabilities, Long-term debt, and Other liabilities) Note: Round your answer to 2 decimal places. b. What is the ratio of total long-term debt to total long-term capital? Note: Round your answer to 2 decimal places. c. What is its net working capital? d. What is its current ratio? Note: Round your answer to 2 decimal places. $ 170 215 140 350 $ 875 a Debt-equity ratio b. Long-term debt-to-capital ratio c. Net working capital d. Current ratioarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- College Accounting, Chapters 1-27 (New in Account...AccountingISBN:9781305666160Author:James A. Heintz, Robert W. ParryPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305666160/9781305666160_smallCoverImage.gif)
College Accounting, Chapters 1-27 (New in Account...
Accounting
ISBN:9781305666160
Author:James A. Heintz, Robert W. Parry
Publisher:Cengage Learning