Question
In: Finance
Using the table below create SinCo's Income Statement for 2013 and 2014.(Do not round intermediate calculations....
Using the table below create SinCo's Income Statement for 2013 and 2014.(Do not round intermediate calculations. Round your answer to 2 decimal places.)
| 2017 | 2018 | |
|---|---|---|
| Revenue | $4,000 | 4053 |
| Cost of Good Sold | 1,600 | 1,702 |
| Depreciation | 500 | 505 |
| Inventory | 300 | 352 |
| SG&A | 500 | 545 |
| Interest Expenses | 150 | 160 |
| Common Stock and Paid-in Capital | 2,200 | 2,200 |
| Federal and State Taxes (35% of EBT) | 400 | |
| Accounts Payable | 300 | 315 |
| Accounts Receivable | 400 | 437 |
| Net Fixed Assets | 5,000 | 5269 |
| Retained Earnings (Balance Sheet) | 1,000 | |
| Long-Term Debt | 2,000 | 2338 |
| Notes Payable | 1,000 | 855 |
| Dividends Paid | 410 | 410 |
| Cash | 800 |
| What is SinCo's EBITDA for 2014? | |
| What is SinCo's EBIT for 2014? | |
| What is SinCo's Net Income for 2014? |
Now uses the above table to create a Balance Sheet for 2013 and 2014
| What is SinCo's 2014 Retained Earnings | |
| What is Total Liabilities and Shareholders Equity | |
| What is SinCo's Total Assets | |
| What is SinCo's 2014 Cash | |
| What is SinCo's 2014 Total Current Assets |
Solutions
Expert Solution
It is assumed that Question ask the income statement for the year 2018. It is mistakely reprint in Question like 2014.
| Income statement for the year 2018 | ||||||
| Revenue | 4053 | |||||
| Less: | Cost of Goods sold | -1072 | ||||
| Less: | Selling, Gnereal & Administration Exp | -545 | ||||
| EBITDA | 2436 | |||||
| Less: | Depreciation | -505 | ||||
| EBIT | 1931 | |||||
| Less: | Interest Expense | -160 | ||||
| EBT | 1771 | |||||
| Less: | Tax @ 35% | -619.85 | ||||
| EAT | 1151.15 | |||||
| Add: | Depreciation | 505 | ||||
| EATand Depreciation | 1656.15 | |||||
| Lees: | Dividend Paid | -410 | ||||
| Retained Earning | 1246.15 | |||||
EBITDA for 2018 is = 2436
EBIT for 2018 is = 1931
Net Income after Dividend = 1246.15
Retained Earning for 2018 is = 1246.15
Total Liabilities = Common stock + Accounts Payable + Notes Payable + Retained Earning + Long term Debt
Total Liabilities = 2200 + 315 + 855 + 1246.15 + 2338
Total Liabilities = 6954.15
Share Holders Equity = 2200 + 1246.15 = 3446.15
Total Assets = Inventory + Common stock + Accounts Recievable + Net fixed Assets + cash
6954.15 = 352 + 2200 + 437 + 5269 + Cash
Cash = 1303.85
Total Assets = 6954.15
Total current Assets = Inventry + Accounts Recievables + Cash
Total Current Assests = 352 + 437 + 1303.85
Total Current Assets = 2092.85
If you have any query related to above answer then you can ask me in a comment
My priority is yours satisfaction
Thanks.
jeff jeffy answered 2 years agoRelated Solutions
Using the table below create SinCo's Income Statement for 2013 and 2014.(Do not round intermediate calculations....
Using the table below create SinCo's Income Statement for 2013
and 2014.(Do not round intermediate calculations. Round
your answer to 2 decimal places.)
2013
2014
Revenue
$4,000
5252
Cost of Good Sold
1,600
2,101
Depreciation
500
524
Inventory
300
335
SG&A
500
534
Interest Expenses
150
175
Common Stock and
Paid-in Capital
2,200
2,200
Federal and State Taxes
(35% of EBT)
400
Accounts Payable
300
354
Accounts
Receivable
400
424
Net Fixed Assets
5,000
4962
Retained Earnings
(Balance Sheet)
1,000...
Fill in the missing numbers in the following income statement: (Do not round intermediate calculations and...
Fill in the missing numbers in the following income statement:
(Do not round intermediate calculations and round your answers to
the nearest whole number, e.g. 32.)
Sales $ 644,000
Costs 345,500
Depreciation 96,200
EBIT $
Taxes (40%)
Net income$
What is the OCF? (Do not round intermediate calculations and
round your answer to the nearest whole number, e.g. 32.)
OCF $
What is the depreciation tax shield? (Do not round
intermediate calculations and round your answer to...
Complete the following using present value. (Use the Table provided.) (Do not round intermediate calculations. Round...
Complete the following using present value. (Use the Table
provided.) (Do not round intermediate calculations. Round
the "PV factor" to 4 decimal places and final answer to the nearest
cent.)
Amount desired at end of period
Length of time
Rate
Compounded
On PV Table
PV factor used
PV of amount desired at end of period
Period used
Rate used
$10,700
4 years
12%
Monthly
%
$
Complete the following using present value. (Use the Table provided.) (Do not round intermediate calculations. Round...
Complete the following using present value. (Use the Table
provided.) (Do not round intermediate calculations. Round the "PV
factor" to 4 decimal places and final answer to the nearest cent.)
Amount desired at end of period Length of time Rate Compounded On
PV Table PV factor used PV of amount desired at end of period
Period used Rate used $10,700 4 years 12% Monthly % $
Complete the following table: (Use Table 15.1) (Do not round intermediate calculations. Round your answers to...
Complete the following table: (Use Table 15.1) (Do not
round intermediate calculations. Round your answers to the nearest
cent.)
First
Payment
Broken Down Into—
Selling
price
Down payment
Amount
mortgage
Rate
Years
Monthly
payment
Interest
Principal
Balance at end of month
$150,000
$30,000
$120,000
7%
30
$
$
$
$
Complete the following using present value. (Use the Tableprovided.) (Do not round intermediate calculations. Round...
Complete the following using present value. (Use the Table
provided.) (Do not round intermediate calculations. Round
the "PV factor" to 4 decimal places and final answer to the nearest
cent.)Amount desired at end of periodLength of timeRateCompoundedOn PV Table 12.3PV factor usedPV of amount desired at end of periodPeriod usedRate used$18,1005 years24%Quarterly%$
For each of the following, compute the future value: (Do not round intermediate calculations and round...
For each of the following, compute the future value: (Do
not round intermediate calculations and round your answers to 2
decimal places, e.g., 32.16.)
Present Value
Years
Interest Rate
Future Value
$
2,450
10
13
%
$
9,853
23
8
103,305
17
6
241,382
33
4
For each of the following, compute the present value: (Do not round intermediate calculations and round...
For each of the following, compute the present value:
(Do not round intermediate calculations and round your
answers to 2 decimal places, e.g., 32.16.)
Present Value
Years
Interest Rate
Future Value
$
11
5
%
$
17,828
3
10
42,017
15
13
795,382
20
12
652,816
For each of the following, compute the future value: (Do not round intermediate calculations and round...
For each of the following, compute the future value: (Do
not round intermediate calculations and round your answers to 2
decimal places, e.g., 32.16.)
Present Value
Years
Interest Rate
Future
Value
$
1,850
11
13
%
$
7,952
7
9
68,355
14
12
175,796
8
6
What is the PV of $260 received in: (Do not round intermediate calculations. Round your answers...
What is the PV of $260 received in: (Do not round intermediate
calculations. Round your answers to 2 decimal places.)
a. Year 8 (at a discount rate of 3%)? Present value $
b. Year 8 (at a discount rate of 15%)? Present value $
c. Year 13 (at a discount rate of 27%)? Present value $
d. Each of years 1 through 3 (at a discount rate of 14%)?
Present value $
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- 4. Why did the United States and the Soviet Union find themselves in a “Cold War”...
- The Facts: Ann and Bill decided to start a coffee shop. They agreed Bill would provide...
- MARGI sells different types of wine. Customers place orders to the most popular “Summer Wine” at...
- A firm's bonds have a maturity of 8 years with a $1,000 face value, have an...
- Naive reasoning suggests that a string theory vacuum with cosmological constant Lambda1 is always unstable as...
- I. Design and code a class Rectangle that has the following properties: Two private members double...
- A bond has a $1,000 par value, 10 years to maturity, and an 8% annual coupon...
ADVERTISEMENT