Reference no: EM131659930
Question #1
A. Using the below account entries, prepare a Balance Sheet (BS) for years 2012 thru 2016:
|
|
2012
|
2013
|
2014
|
2015
|
2016
|
|
Accounts Payable
|
$331.00
|
$413.75
|
$517.19
|
$646.48
|
$808.11
|
|
Accounts Receivable
|
$305.00
|
$341.60
|
$382.59
|
$428.50
|
$479.92
|
|
Accrued Liabilities
|
$126.00
|
$133.56
|
$141.57
|
$150.07
|
$159.07
|
|
Cash
|
$327.00
|
$277.95
|
$236.26
|
$200.82
|
$170.70
|
|
Common Stock
|
$228.00
|
$214.32
|
$201.46
|
$189.37
|
$178.01
|
|
Furniture and Fixtures
|
$316.00
|
$322.32
|
$328.77
|
$335.34
|
$342.05
|
|
Inventories
|
$217.00
|
$271.25
|
$339.06
|
$423.83
|
$529.79
|
|
Land/Buildings
|
$2,177.00
|
$2,242.31
|
$2,309.58
|
$2,378.87
|
$2,450.23
|
|
Accumulated Depreciation
|
$2,056.00
|
$2,199.92
|
$2,353.91
|
$2,518.69
|
$2,695.00
|
|
Long-Term Debt
|
$798.00
|
$997.50
|
$1,246.88
|
$1,558.59
|
$1,948.24
|
|
Machinery/Equipment
|
$1,789.00
|
$1,878.45
|
$1,972.37
|
$2,070.99
|
$2,174.54
|
|
Marketable Securities
|
$51.00
|
$54.06
|
$57.30
|
$60.74
|
$64.39
|
|
Notes Payable
|
$101.00
|
$113.12
|
$126.69
|
$141.90
|
$158.93
|
|
Other Fixed Assets
|
$96.00
|
$96.96
|
$97.93
|
$98.91
|
$99.90
|
|
Preferred Stock
|
$109.00
|
$103.55
|
$98.37
|
$93.45
|
$88.78
|
|
Retained Earnings
|
$1,843.00
|
$1,717.38
|
$1,568.45
|
$1,389.30
|
$1,172.19
|
|
Vehicles
|
$314.00
|
$408.20
|
$530.66
|
$689.86
|
$896.82
|
B. Once you have completed your BS in Part A above, convert your BS to a "Common Size BS" for each year (2012 thru 2016)
C. Utilizing the Common Size BS you developed in Part B, identify at least TWO (2) trends that may indicate the company may be struggling
Question #2
The ABC Company produced the following sales. Determine the monthly cash in-flows for January thru June 2016 using the terms of sale:
Cash 60%
Net 30 25%
Net 60 15%
|
|
Jan-16
|
Feb-16
|
Mar-16
|
Apr-16
|
|
Sale
|
$52,152.00
|
$70,405.20
|
$95,047.02
|
$128,313.48
|
Question #3
ABC Company accountants generated the following data. Prepare an Income Statement (IS) for years 2012 thru 2016:
|
|
2012
|
2013
|
2014
|
2015
|
2016
|
|
Cost of Goods Sold (COGS)
|
$1,999.00
|
$2,398.80
|
$2,878.56
|
$3,454.27
|
$4,145.13
|
|
Depreciation Expense
|
$223.00
|
$245.30
|
$269.83
|
$296.81
|
$326.49
|
|
General &Administrative Expense
|
$187.00
|
$192.61
|
$198.39
|
$204.34
|
$210.47
|
|
Interest Expense
|
$91.00
|
$91.00
|
$91.00
|
$91.00
|
$91.00
|
|
Lease Expense
|
$45.00
|
$45.00
|
$45.00
|
$45.00
|
$45.00
|
|
Preferred Stock Dividends
|
$10.00
|
$10.00
|
$10.00
|
$10.00
|
$10.00
|
|
Sales Revenues
|
$3,529.00
|
$3,881.90
|
$4,270.09
|
$4,697.10
|
$5,166.81
|
|
Selling Expense
|
$108.00
|
$124.20
|
$142.83
|
$164.25
|
$188.89
|
|
Taxes (29%)
|
$254.00
|
$228.00
|
$187.00
|
$128.00
|
$46.00
|
Question #4
As part of the initial outlays to get the ABC Company up &running, they needed to purchase $625,000 in equipment. It also cost $12,356 for delivery of the equipment and $62,644 in installation costs.
A. Develop a depreciation table for the asset(s)utilizing the 7-year MACRS schedule found in Table A-1 of IRS Pub 946:
B. What is the "Book Value" of the asset(s) at the end of year 5?
C. If ABC Company decides to sell the assets for $207,828.10 at the end of year eight (8), how much taxes would ABC Company have to pay as a result of this transaction?
Assumptions:
o ABC Company breaks-even that year (realizing a profit of $0) before the sale (so the tax paid by ABC will be a result of this sale only)
o Capital Gains Tax Rate is 15%
o Ordinary Tax Rate is 29%
Question #5
A. Develop a Loan Amortization Table for the following two loans:
B. Calculate the total "interest paid" over the life of each loan:
|
|
Loan #1
|
Loan #2
|
|
Loan amount:
|
$300,000.00
|
$125,00
|
|
Annual Interest Rate
|
5.00%
|
3.00%
|
|
Duration/Terms
|
30 Years of annual payments
|
10 Years ofmonthly payments
|
Question #6 Cash Flow Statements
A. Answer the following True/False questions:
|
1. An increase in merchandise inventory will be shown as a reduction in cash flow
|
True False
|
|
2. A decrease in Accounts Payable will be shown as an increase in cash flow
|
True False
|
|
3. The purchase of a delivery truck will cause a decrease in cash from investing activities
|
True False
|
|
4. The proceeds from the issuance of common stock will be reported as an increase in cash from financing activities
|
True False
|
|
5. The proceeds from the sale of equipment formerly used in the business has a positive effect on cash flow
|
True False
|
B. Indicate which part of the Cash Flow Statement will be effected by the following scenarios
|
1. Decrease in depreciation
|
Operating Investing Financing
|
|
2. Proceeds from the sale of long-term assets
|
Operating Investing Financing
|
|
3. Increase in inventory
|
Operating Investing Financing
|
|
4. Decrease in accounts payable
|
Operating Investing Financing
|
|
5. Payment of dividends
|
Operating Investing Financing
|
Question #7
You are the owner of a small business. An opportunity to expand into a new market niche arose. It requires an initial equipment investment of $500,000. You will finance the entire amount with a 5-year payback at 8% interest rate (annual payments).
Depreciation will follow MACRS-3
Sales projections look very promising as shown below:
- $250,000 in first year's projected sales
- Sales growth is expected to increase by 35% over the previous year's sales
- COGS is expected to be 25% of that years' sales
Business ordinary tax rate is 29%
A. Develop the following:
a. Loan amortization table
b. Depreciation table
c. Income Statement
d. Cash Flow Statement
B. Based on the information provided inthe statements, would you pursue the opportunity? In ~50 words, explain why or why not.