Question
In: Finance
Complete this partial comparative balance sheet by vertical analysis. Round percents to the nearest hundredth. (using...
Complete this partial comparative balance sheet by vertical analysis. Round percents to the nearest hundredth. (using excel)
| Column1 | Column2 | Column3 | Column4 | Column5 |
| 2017 | 2016 | |||
|
Assets |
amount | percent | amount | percent |
| Current assets: | ||||
| a. Cash | $38,000 | $35,000 | ||
| b. Accounts receivable | $19,000 | $18,000 | ||
| c.merchandise inventory | $16,000 | $11,000 | ||
| d. prepaid exoenses | $20,000 | $16,000 | ||
| . | . | . | ||
| . | . | . | ||
| . | . | . | ||
| total current assets | $180,000 | $140,000 | ||
What is the amount of change in merchandise inventory and the percent increase?
Solutions
jeff jeffy answered 1 year agoRelated Solutions
Complete the following balance sheet using the information given. Round account balances to the nearest dollar....
Complete the following balance sheet using the information
given. Round account balances to the nearest dollar.
Balance Sheet
Income Statement
Cash
Sales (All Credit)
$40,000
Accounts receivable
Cost of goods sold
20,000
Inventory
Operating expenses
12,000
Net fixed assets
Interest expense
200
Total assets
Taxes
2 730
Net income
$5,070
Accounts payable
Short-term notes payable
$1,425
Ratios:
Long-term debt
Profit Margin =
12.675%
Common stock
$5,000
Return on Equity =
15%
Retained earnings
Quick Ratio =
1.2
Total Liabilities and...
Figure the total balance owed for each of the following (round to the nearest hundredth): 1)...
Figure the total balance owed for each of the following (round
to the nearest hundredth):
1) Retailer purchase items from whole seller with the following
terms;
shovels@ 12/ea; purchased 12 shovels on June 20 "10/10 net
30"
brooms @8/ea ; purchased 50 brooms on June 30 "15/5 net
30"
boxes of nails @ 50/each;purchased 20 boxes July 1 "2/10 net
30"
**days of Holiday included towards total days counted
Purchaser will pay bill "in full" today. How much does she...
Figure the total balance owed for each of the following (round to the nearest hundredth): 1)...
Figure the total balance owed for each of the following (round
to the nearest hundredth):
1) Retailer purchase items from whole seller with the following
terms;
shovels@ 12/ea; purchased 12 shovels on June 20 "10/10 net
30"
brooms @8/ea ; purchased 50 brooms on June 30 "15/5 net
30"
boxes of nails @ 50/each;purchased 20 boxes July 1 "2/10 net
30"
**days of Holiday included towards total days counted
Purchaser will pay bill "in full" today. How much does she...
Vertical Analysis of Comparative Financial Statements Amounts from the comparative income statement and balance sheet of...
Vertical Analysis of Comparative Financial Statements
Amounts from the comparative income statement and balance sheet
of Miller Electronics Corporation for the last two years are as
follows:
Miller Electronics Corporation
Comparative Income Statement
For Years Ended December 31, 20-2 and 20-1
20-2
20-1
Net Sales (all on account)
$662,120
$427,020
Cost of goods sold
395,040
263,840
Gross profit
$267,080
$163,180
Administrative expenses
$63,920
$43,090
Selling expenses
66,123
44,353
Total operating expenses
$130,043
$87,443
Operating income
$137,037
$75,737
Interest expense
1,268 ...
perating Asset Management Analysis Partial comparative balance sheet and income statement information for Posad Company is...
perating Asset Management Analysis Partial comparative balance
sheet and income statement information for Posad Company is as
follows: 2014 2013 Cash $ 13,600 $ 10,400 Marketable securities
7,200 17,200 Accounts receivable (net) 44,800 35,600 Inventory
54,400 49,600 Total current assets $120,000 $112,800 Accounts
payable $ 40,000 $ 28,200 Net sales $322,560 $220,720 Cost of goods
sold 217,600 203,360 Gross margin $104,960 $ 17,360 In 2012, the
year-end balances for Accounts Receivable and Inventory were
$32,400 and $51,200, respectively. Accounts Payable...
Use the z-score table to answer the question. Note: Round z-scores to the nearest hundredth and...
Use the z-score table to answer the question. Note:
Round z-scores to the nearest hundredth and then find the
required A values using the table.
A psychologist finds that the intelligence quotients of a group of
patients are normally distributed, with a mean of 101 and a
standard deviation of 16. Find the percent of the patients with the
following IQs.
(a) above 113
%
(b) between 89 and 119
%
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.1x
Days sales outstanding: 30.5 days^a
Inventory turnover ratio: 4x
Fixed assets turnover: 2.5x
Current ratio: 2.4x
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
25%
aCalculation is based on a 365-day year. Do not round intermediate
calculations. Round your answer to the nearest cent.
Balance
Sheet
Cash
$
Current liabilities
$
Accounts receivable
Long-term debt
41,250...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.3x
Days sales outstanding: 37.5 daysa
Inventory turnover ratio: 7x
Fixed assets turnover: 3.5x
Current ratio: 2.1x
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
35%
aCalculation is based on a 365-day year. Do not round
intermediate calculations. Round your answer to the nearest
cent.
Balance Sheet
Cash
$
Current liabilities
$
Accounts receivable
Long-term debt
52,500...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.4x
Days sales outstanding: 31.5 daysa
Inventory turnover ratio: 7x
Fixed assets turnover: 3x
Current ratio: 2.2x
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
15%
aCalculation is based on a 365-day year. Do not round intermediate
calculations. Round your answer to the nearest cent.
Balance
Sheet
Cash
$
Current liabilities
$
Accounts receivable
Long-term debt
56,250...
BALANCE SHEET ANALYSIS Complete the balance sheet and sales information using the following financial data: Total...
BALANCE SHEET ANALYSIS
Complete the balance sheet and sales information using the
following financial data:
Total assets turnover: 1.4x
Days sales outstanding: 34 daysa
Inventory turnover ratio: 4x
Fixed assets turnover: 3.5x
Current ratio: 2.5x
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
35%
aCalculation is based on a 365-day year. Do not round
intermediate calculations. Round your answer to the nearest
cent.
Balance Sheet
Cash
$
Current liabilities
$
Accounts receivable
Long-term debt
56,250...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 1) The 3rd bright fringe of a double slit interference pattern is 30.0 cm above the...
- A solar cell generates a potential difference of 0.320 V when a 445.0 ? resistor is...
- A ceiling fan consists of a small cylindrical disk with 5 thin rods coming from the...
- You measure the following quantities as A = 1.0 m ± 0.2 m, B = 2.0...
- Froya Fabrikker A/S of Bergen, Norway, is a small company that manufactures specialty heavy equipment for...
- When the electricity goes out on your campus, a backup source powers the servers that handle...
- I am having trouble with my assignment and getting compile errors on the following code. The...
ADVERTISEMENT