Question
In: Accounting
Please don't answer Using the following financial data construct a balance sheet and income statment. Expenses...
Please don't answer
Using the following financial data construct a balance sheet and income statment.
|
Solutions
Expert Solution
| 1. Category | 2012 | 2013 | % | ||
| Current assets | 7000000 | 46.67% | 9000000 | 60.00% | Increase |
| Total fixed assets | 8000000 | 53.33% | 6000000 | 40.00% | Decrease |
| Total assets | 15000000 | 100.00% | 15000000 | 100.00% | |
| Current liabilities | 3000000 | 20.00% | 1000000 | 6.67% | Decrease |
| Long term debt | 4000000 | 26.67% | 4000000 | 26.67% | Same |
| Owner’s equity | 8000000 | 53.33% | 10000000 | 66.67% | Increase |
| Total liabilities & owner’s equity | 15000000 | 100.00% | 15000000 | 100.00% | |
| Current ratio will increase --liquidity position has improved | |||||
| Equity participation is more ,whereas, debt funding % remains the same. | |||||
| 2. Salaries | 42000 | |
| Interest Income | 150 | |
| Dividend Income | 190 | |
| Total Income | 42340 | |
| Less: Expenses: | ||
| Mortgage payment | 7980 | |
| Food | 2400 | |
| Transportation | 1200 | |
| Automobile payment | 3060 | |
| Clothes & personal | 2000 | |
| Student loan payment | 1700 | |
| Propert taxes | 1100 | |
| Utilities | 3000 | |
| Insurance | 2100 | |
| Income taxes | 9700 | |
| Recreation & vacation | 2000 | 36240 |
| Family’s disposable income | 6100 | |
| 3. Statement of financial position | |||
| Assets | Liabilities | ||
| Cash accounts: | Student loan balance | 6000 | |
| Cash | 50 | Automobile loan balance | 12000 |
| Checking account | 2500 | Credit card balance | 4000 |
| Savings account | 5850 | Mortgage loan balance | 99000 |
| Savings | 5800 | Net woth (Bal.fig.) | 40800 |
| Investments: | |||
| Stocks & bonds | 2600 | ||
| 401(K) retirement a/c | 15000 | ||
| Assets for use: | |||
| Residence | 110000 | ||
| Automobile | 12000 | ||
| Furniture,clothing Jewelry | 8000 | ||
| 161800 | 161800 | ||
| 4. Income statement | ||
| Net sales | 500000 | |
| Less: COGS | 250000 | |
| Gross profit | 250000 | |
| Less: Operating expenses: | ||
| Salaries | 100000 | |
| Rent | 24000 | |
| Utilities | 25000 | |
| Payroll taxes | 25000 | |
| Insurance | 12000 | 186000 |
| Operating Income | 64000 | |
| Less: Non-operating expense | ||
| Interest expense | 5450 | |
| Net profit | 58550 | |
| 5. Horizontal/trend analysis | ||||
| 2012 | 2013 | Horizontal Analysis(2013-2012)/2012 | ||
| Current assets | 7000000 | 9000000 | 28.57% | Increase |
| Total fixed assets | 8000000 | 6000000 | -25.00% | Decrease |
| Total assets | 15000000 | 15000000 | 0.00% | |
| Current liabilities | 3000000 | 1000000 | -66.67% | Decrease |
| Long-term debt | 4000000 | 4000000 | 0.00% | Same |
| Owner’s equity | 8000000 | 10000000 | 25.00% | Increase |
| Total liabilities & owner’s equity | 15000000 | 15000000 | 0.00% | |
| Leads to same conclusion as Vertical analysis |
ekkarill92 answered 1 year agoRelated Solutions
4) Using the balance sheet from #3, construct an income statement and balance sheet for ...
4) Using the balance sheet from #3, construct an income
statement and balance sheet for
the first month of operation, given the
following information:
Sales
$104,000.00
Collections
$77,000.00
Purchases (paid for half)
$60,000.00
Ending inventory
$57,000.00
Equipment Depreciation
$18,000.00
Vehicle Depreciation
$2,000.00
Heat (due next month)
$450.00
Electricity
$325.00
Telephone
$230.00
Advertising
$1,200.00
Salaries
$15,500.00
Payroll Tax Expense
$1,700.00
Office Supplies
$200.00
Insurance (due next month)
$1,250.00
Loan payment
$3,500.00
principal
$1,500.00
interest
$2,000.00
Legal fees...
Given the following information please construct a balance sheet and an income statement for the company....
Given the following information please construct a balance sheet
and an income statement for the company. It provides software via a
cloud subscription. There is no inventory.
All information in $000
Total
Revenues
5,374
Cash
908
Common
Stock
651
Cost of Revenues
Subscription
925
Interest Expense
16
Additional Paid in
Capital
3,954
Retained
Earnings
(630)
Cost of Revenues Professional Services
365
Gross Margin
4,084
Short term
securities
87
Long term
debt
2,328
Accounts
Receivable ...
Given the following information please construct a balance sheet and an income statement for the company....
Given the following information please construct a balance sheet
and an income statement for the company. It provides software via a
cloud subscription. There is no inventory.
All information in $000
Total
Revenues
5,374
Cash
908
Common
Stock
651
Cost of Revenues
Subscription
925
Interest Expense
16
Additional Paid in
Capital
3,954
Retained
Earnings
(630)
Cost of Revenues Professional Services
365
Gross Margin
4,084
Short term
securities
87
Long term
debt
2,328
Accounts
Receivable ...
Based on the following financial information, construct the balance sheet and income statement below for Tonka...
Based on the following financial information, construct the
balance sheet and income statement below for Tonka Trucking LLC for
the year ending December 31, 2019. Be sure to format them as
accurately as possible. Accounts Receivable $40,000 Depreciation
Expense $50,000 Accumulated Depreciation $200,000 Cost of Goods
Sold $50,000 Income Tax Expense $50,000 Cash $50,000 Sales Revenue
$400,000 Equipment (Net of Accumulation) $200,000 Selling, General,
and Administrative Expenses $100,000 Common Stock (1,000 shares)
$100,000 Accounts Payable $50,000 Retained Earnings $200,000
Interest...
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...
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.2x
Days sales outstanding: 39.5 daysa
Inventory turnover ratio: 4x
Fixed assets turnover: 3x
Current ratio: 2.5x
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
50,000...
Complete the balance sheet and sales data (fill in the blanks), using the following financial data:...
Complete the balance sheet and sales data (fill in the blanks),
using the following financial data: Debt/net worth 60% Acid test
ratio 1.2 Asset turnover 1.5 times Day sales outstanding in
accounts receivable 40 days Gross profit margin 30% Inventory
turnover 6 times Balance sheet Cash ________ Accounts
payable ________ Accounts receivable ________
Common stock $15,000 Inventories ________ Retained
earnings $22,000 Plant & equipment ________ Total
assets ________ Total liabilities ________
& capital Sales ________ Cost of goods sold
________.
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- NPV Your division is considering two investment projects, each of which requires an up-front expenditure of...
- Please repond with a 200 word limit paragraph no copy or paste your own words!!! What...
- Participant Reactivity Think about how participants might react to environmental cues in an experimental situation and...
- Describe scenarios when you would use a Fixed-size virutal disk, a Dynamic virtual disk, and a...
- A conductive sphere with radius ? = 1 ? has been increased to the potential ?0...
- Define a char variable. Read a char value from the keyboard into the variable. Print the...
- If you wanted to store a birthday within code, what class would you use in Java?...
ADVERTISEMENT