Question
In: Accounting
Complete the model and state the cash balance required to balance the balance sheet in Year...
Complete the model and state the cash balance required to balance the balance sheet in Year 1.
| Assumptions | Year 0 | Year 1 |
| Investments growth | 5.0 | |
| Accounts payable % net income | 50.0% | |
| Long term debt increase (decrease) | 1.0 | |
| Income statement | Year 0 | Year 1 |
| Net income | 12.0 | 14.0 |
| Balance sheet | Year 0 | Year 1 |
| Cash | 12.0 | |
| Investments | 60.0 | |
| Total assets | 72.0 | |
| Accounts payable | 12.0 | |
| Long term debt | 20.0 | |
| Equity | 40.0 | |
| Total liabilities and equity | 72.0 | |
| Check | OK | |
| Cash flow statement | ||
| Net income | ||
| Increase (decrease) in accounts payable | ||
| Cash flow from operations | ||
| (Increase) decrease in investments | ||
| Cash flow from investing activities | ||
| Inc (dec) in long term debt | ||
| Cash flow from financing activities | ||
| Beginning cash | ||
| Net cash flow | ||
| Ending cash | 12 |
Solutions
Expert Solution
By preparing the Cash Flow Statement using the assumptions and other information given, The closing balance of cash as at the end of Year-1 is calculated and the balance sheet is prepared using the same.
ekkarill92 answered 2 years agoRelated Solutions
Complete the following Balance Sheet ASSETS Current Assets Cash
Complete the following Balance
Sheet
ASSETS
Current
Assets
Cash
$ 250,000
Accounts
Receivable
($_________
less allowance for Doubtful
Accounts)
$1,320,000
Inventory
$1,410,000
Total Current
Assets
$_________
Land
$_________
Plant &
Equipment ($2,800,000 less
Accumulated Depreciation
________)
$2,110,000
TOTAL
ASSETS
$5,390,000
LIABILITIES AND
STOCKHOLDERS EQUITY
Current
Liabilities
Accounts
Payable
$ 620,000
Notes
Payable to
banks
$ 130,000
Accrued
Wages
$________
Total...
State Bank has the following year-end balance sheet (in millions): Assets Liabilities and equity Cash $ ...
State Bank has the following year-end balance sheet (in
millions):
Assets
Liabilities and equity
Cash
$
10
Deposits
$
90
Loans
$
90
Equity
$
10
Total assets
$ 100
Total liabilities and
equity
$ 100
The loans primarily are fixed-rate, medium-term loans, while the
deposits are either short-term or variable-rate deposits. Rising
interest rates have caused the failure of a key industrial company,
and as a result, 3 percent of the loans are considered
uncollectable and thus have no...
Complete, in good form, an Income Statement, Balance Sheet, and Statement of Cash Flows for the...
Complete, in good form, an Income Statement, Balance Sheet, and
Statement of Cash Flows for the following transactions.
Transactions:
T1
Company issues $200,000 of common stock @ $8.00 per share.
T2
Company issues preferred stock @ 7% for $22 per share.
T3
The company borrows on April 1st, 1 million dollars @ 7%
interest rate
T4
On June 1st, The company purchases 15 taxi cabs for $20,000, 5%
salvage value, 5-year life
T5
Revenue for the whole year was $600,000...
Year-End Balance Sheet and Statement of Cash Flows–Indirect Method The balance sheet of Poodle Company at...
Year-End Balance Sheet and Statement of Cash Flows–Indirect
Method
The balance sheet of Poodle Company at the end of 2016 is
presented here, along with certain other information for
2017:
December 31, 2016
Cash
$155,000
Accounts receivable
140,000
Total current assets
$295,000
Land
$100,000
Plant and equipment
700,000
Accumulated depreciation
(175,000)
Investments
125,000
Total long-term assets
$750,000
Total assets
$1,045,000
Current liabilities
$325,000
Bonds payable
$100,000
Common stock
$500,000
Retained earnings
120,000
Total stockholders’ equity
$620,000
Total liabilities and
stockholders’...
Year-End Balance Sheet and Statement of Cash Flows–Indirect Method The balance sheet of Poodle Company at...
Year-End Balance Sheet and Statement of Cash Flows–Indirect
Method
The balance sheet of Poodle Company at the end of 2016 is
presented here, along with certain other information for
2017:
December 31, 2016
Cash
$155,000
Accounts receivable
140,000
Total current assets
$295,000
Land
$100,000
Plant and equipment
700,000
Accumulated depreciation
(175,000)
Investments
125,000
Total long-term assets
$750,000
Total assets
$1,045,000
Current liabilities
$325,000
Bonds payable
$100,000
Common stock
$500,000
Retained earnings
120,000
Total stockholders’ equity
$620,000
Total liabilities and
stockholders’...
Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for...
Balance Sheet Analysis
Complete the balance sheet and sales information in the table
that follows for J. White Industries using the following financial
data:
Total assets turnover: 1.7
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
20%
Total liabilities-to-assets ratio: 50%
Quick ratio: 0.80
Days' sales outstanding (based on 365-day year): 36.5 days
Inventory turnover ratio: 3.25
Do not round intermediate calculations. Round your answers to
the nearest whole dollar.
Partial Income Statement
Information
Sales
$...
Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for...
Balance Sheet Analysis
Complete the balance sheet and sales information in the table
that follows for J. White Industries using the following financial
data:
Total assets turnover: 1.2
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
25%
Total liabilities-to-assets ratio: 45%
Quick ratio: 0.80
Days' sales outstanding (based on 365-day year): 36.5 days
Inventory turnover ratio: 3.75
Do not round intermediate calculations. Round your answers to
the nearest whole dollar.
Partial Income Statement
Information
Sales
$ ...
Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for...
Balance Sheet Analysis
Complete the balance sheet and sales information in the table
that follows for J. White Industries using the following financial
data:
Total assets turnover: 1.8
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
20%
Total liabilities-to-assets ratio: 45%
Quick ratio: 1.00
Days' sales outstanding (based on 365-day year): 36.5 days
Inventory turnover ratio: 3.75
Do not round intermediate calculations. Round your answers to
the nearest whole dollar.
Partial Income Statement
Information
Sales
$ ...
Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for...
Balance Sheet Analysis
Complete the balance sheet and sales information in the table
that follows for J. White Industries using the following financial
data:
Total assets turnover: 1.2
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales =
30%
Total liabilities-to-assets ratio: 50%
Quick ratio: 1.10
Days' sales outstanding (based on 365-day year): 36.5 days
Inventory turnover ratio: 3.25
Do not round intermediate calculations. Round your answers to
the nearest whole dollar.
Partial Income Statement
Information
Sales
$ ...
Balance Sheet Analysis Complete the balance sheet and sales information in the table that follows for...
Balance Sheet Analysis Complete the balance sheet and sales
information in the table that follows for J. White Industries using
the following financial data:
Total assets turnover: 2.7
Gross profit margin on sales: (Sales - Cost of goods sold)/Sales
= 21%
Total liabilities-to-assets ratio: 60%
Quick ratio: 1.15
Days sales outstanding (based on 365-day year): 33 days
Inventory turnover ratio: 5.0
Round your answers to the nearest whole dollar.
Partial Income Statement Information
Sales $
Cost of goods sold $...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- Explain the use of neural networking modeling in predictive analytics.
- Current Market Mix of Netflix, as detail as possible, please.
- This is all one question, thank you so much in advance! You must evaluate a proposal...
- X Company is considering the purchase of a new processor that costs $200,000. Shipping and setup...
- There are a large number of tasks involved in information technology and programming, and many of...
- Using one quantitative and one qualitative health policy research method described in this chapter, design a...
- What is the Rawls' solution to the age-old question of social (economic / distributive) justice?...
ADVERTISEMENT