For 20Y2, McDade Company reported a decline in net income. At the end of the year, T. Burrows, the president, is presented with the following condensed comparative income statement:
| McDade Company Comparative Income Statement For the Years Ended December 31, 20Y2 and 20Y1 |
|||
| 20Y2 | 20Y1 | ||
| Sales | $361,360 | $304,000 | |
| Cost of goods sold | 262,200 | 190,000 | |
| Gross profit | $99,160 | $114,000 | |
| Selling expenses | $38,350 | $26,000 | |
| Administrative expenses | 21,470 | 16,000 | |
| Total operating expenses | $59,820 | $42,000 | |
| Income from operations | $39,340 | $72,000 | |
| Other revenue | 1,580 | 1,300 | |
| Income before income tax | $40,920 | $73,300 | |
| Income tax expense | 11,500 | 22,000 | |
| Net income | $29,420 | $51,300 | |
Required:
1. Prepare a comparative income statement with horizontal analysis for the two-year period, using 20Y1 as the base year. Round percentages to one decimal place. Use the minus sign to indicate a decrease in the "Increase (Decrease)" columns.
| McDade Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31, 20Y2 and 20Y1 | ||||
| 20Y2 | 20Y1 | Increase (Decrease) - Amount | Increase (Decrease) - Percent | |
| Sales | $361,360 | $304,000 | $ | % |
| Cost of goods sold | 262,200 | 190,000 | % | |
| Gross profit | $99,160 | $114,000 | $ | % |
| Selling expenses | $38,350 | $26,000 | $ | % |
| Administrative expenses | 21,470 | 16,000 | % | |
| Total operating expenses | $59,820 | $42,000 | $ | % |
| Income from operations | $39,340 | $72,000 | $ | % |
| Other revenue | 1,580 | 1,300 | % | |
| Income before income tax | $40,920 | $73,300 | $ | % |
| Income tax expense | 11,500 | 22,000 | % | |
| Net income | $29,420 | $51,300 | $ | % |
2. Net income has_______ from 20Y1 to 20Y2. Sales have ;_______ however, the cost of goods sold has ,_______ causing the gross profit to ________
In: Accounting
At the beginning of the school year, Craig Kovar decided to prepare a cash budget for the months of September, October, November, and December. The budget must plan for enough cash on December 31 to pay the spring semester tuition, which is the same as the fall tuition. The following information relates to the budget:
| Cash balance, September 1 (from a summer job) | $10,850 |
| Purchase season football tickets in September | 200 |
| Additional entertainment for each month | 310 |
| Pay fall semester tuition in September | 5,600 |
| Pay rent at the beginning of each month | 750 |
| Pay for food each month | 690 |
| Pay apartment deposit on September 2 (to be returned December 15) | 750 |
| Part-time job earnings each month (net of taxes) | 1,500 |
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
Open spreadsheet
a. Prepare a cash budget for September, October, November, and December. Enter all amounts as positive values except cash decrease which should be indicated with a minus sign.
| Craig Kovar | ||||||||||||||||||
| Cash Budget | ||||||||||||||||||
| For the Four Months Ending December 31 | ||||||||||||||||||
| September | October | November | December | |||||||||||||||
| Estimated cash receipts from: | ||||||||||||||||||
| $ | $ | $ | $ | |||||||||||||||
| Total cash receipts | $ | $ | $ | $ | ||||||||||||||
| Less estimated cash payments for: | ||||||||||||||||||
| $ | ||||||||||||||||||
| $ | $ | $ | ||||||||||||||||
| Total cash payments | $ | $ | $ | $ | ||||||||||||||
| Cash increase (decrease) | $ | $ | $ | $ | ||||||||||||||
| Cash balance at end of month | $ | $ | $ | $ | ||||||||||||||
b. Are the four monthly budgets that are presented prepared as
static budgets or flexible budgets?
c. What are the budget implications for Craig Kovar?
Craig can see that his present plan sufficient cash. If Craig did not budget but went ahead with the original plan, he would be $ at the end of December, with no time left to adjust.
In: Accounting
Fred and Ida have discovered that if they get divorced in December of this year, file as single taxpayers, and then remarry in the following year, the arrangement would result in significant tax savings. Is this a permissible tax planning strategy?
Note: you are expected to complete this project using current, post-CARES Act law. In other words, apply “new” law to the fact patterns below. To the extent your conclusion is contingent on an unknown fact, you should discuss possible outcomes for different assumptions.
In general, the memos should document the analysis you performed
and conclusions of your research. More specifically, the memos
should reflect the following about each client’s inquiry:
Relevant facts
Issues (questions) identified from the facts
Applicable primary authority (importantly, IRS Publications may
not be your only source for any particular client inquiry)
Conclusions and recommendations reached as a consequence of your
research
Analysis performed (i.e., how the primary authority cited above
addresses the issues)
In: Accounting
Uncollectible Accounts—Percentage of Sales and Percentage of Receivables
At the end of the current year, the accounts receivable account of Parker's Nursery Supplies has a debit balance of $344,120. Credit sales are $2,658,000. Record the end-of-period adjusting entry on December 31, in general journal form, for the estimated uncollectible accounts. Assume the following independent conditions existed prior to the adjustment:
1. Allowance for Doubtful Accounts has a credit balance of $1,985.
a. The percentage of sales method is used and bad debt expense is estimated to be 1% of credit sales. If an amount box does not require an entry, leave it blank.
| DATE | ACCOUNT TITLE | DOC. NO. |
POST. REF. |
DEBIT | CREDIT | ||
|---|---|---|---|---|---|---|---|
| 1 | 20-- Dec. 31 | 1 | |||||
| 2 | 2 | ||||||
| 3 | 3 |
b. The percentage of receivables method is used and an analysis of the accounts produces an estimate of $23,690 in uncollectible accounts. If an amount box does not require an entry, leave it blank.
| DATE | ACCOUNT TITLE | DOC. NO. |
POST. REF. |
DEBIT | CREDIT | ||
|---|---|---|---|---|---|---|---|
| 1 | 20-- Dec. 31 | 1 | |||||
| 2 | 2 | ||||||
| 3 | 3 |
2. Allowance for Doubtful Accounts has a debit balance of $1,160.
a. The percentage of sales method is used and bad debt expense is estimated to be ¾ of 1% of credit sales. If an amount box does not require an entry, leave it blank.
| DATE | ACCOUNT TITLE | DOC. NO. |
POST. REF. |
DEBIT | CREDIT | ||
|---|---|---|---|---|---|---|---|
| 1 | 20-- Dec. 31 | 1 | |||||
| 2 | 2 | ||||||
| 3 | 3 |
b. The percentage of receivables method is used and an analysis of the accounts produces an estimate of $22,330 in uncollectible accounts. If an amount box does not require an entry, leave it blank.
| DATE | ACCOUNT TITLE | DOC. NO. |
POST. REF. |
DEBIT | CREDIT | ||
|---|---|---|---|---|---|---|---|
| 1 | 20-- Dec. 31 | 1 | |||||
| 2 | 2 | ||||||
| 3 | 3 |
In: Accounting
The following are the income statement and balance sheet of company X as at year 2015.
Income Statement
Sales
20,077,000
Cost of goods sold
14,985,000
Other Expenses
2,399,000
Depreciation
655,000
EBIT
2,038,000
Interest
362,000
Taxable income
1,676,000
Tax (40%)
670,400
Net income
1,006,600
Balance Sheet
Assets
Liability and Equity
Current Assets
Current liabilities
Cash
365,040 Account payable
715,680
Account Receivable
1,534,680 Notes payable
1,446,400
Inventory
1,238,500 Total current liabilities
2,162,080
Total current assets
3,138,220
Fixed Assets
Long-term debt
3,825,000
Net plant and equipment
12,315,680 Shareholder equity
Common stock
150,000
Retained earnings
9,316,820
Total equity
9,466,820
Total assets
15,453,900 Total liability and equity
15,453,900
Please calculate the following ratio:
a. Gross margin ratio
b. Quick ratio
c. Debt to Asset ratio
In: Finance
A project will produce an operating cash flow of $15,200 a year for four years. The initial cash investment in the project will be $50,000. The net after-tax salvage value is estimated at $4,000 and will be received during the last year of the project’s life. What is the internal rate of return for this project? Should the project be accepted if the cost of capital is 10%?
Group of answer choices
8.31%; No, project should be rejected
10.81%; Yes, project should be accepted
8.31%; Yes, project should be accepted
10.81%; No, project should be rejected
10.25%; Yes, project should be accepted
In: Finance
A project will produce an operating cash flow of $91,500 a year for three years. The initial cash outlay for
equipment will be $188,000. The net aftertax salvage value of $17,000 will be received at the end of the
project. The project requires $52,000 of net working capital up front that will be fully recovered. What is the
net present value of the project if the required rate of return is 14 percent?
A. $22,318.76 B. $19,002.37 C. $15,450.93 D. $24,670.39 E. $17,488.70
In: Finance
Prepare the cash flow statement for the company for the year 2018 (start with NPAT) and write down your answer for each section. (Do not show the full format, just write down the balance for each section.) (Depreciation Expense for the year 2018 is 500,000 USD)
|
Z&B Company Balance Sheets (USD) |
Z&B Company Income Statement for the Year 2018 (USD) |
||||||||||
|
ASSETS |
31.12.2017 |
31.12.2018 |
|||||||||
|
Current Assets Cash |
520.000 |
460.000 |
Net Sales |
18.000.000 |
|||||||
|
Accounts Receivable |
480.000 |
490.000 |
Cost of Goods Sold |
15.500.000 |
|||||||
|
Inventories |
740.000 |
870.000 |
Gross Profit |
2.500.000 |
|||||||
|
Fixed Assets Tangible Fixed Assets (Net) |
1.760.000 |
1.800.000 |
Operating Expenses |
1.766.000 |
|||||||
|
TOTAL ASSETS |
3.500.000 |
3.620.000 |
Operating Profit |
734.000 |
|||||||
|
Non-operating Expenses |
0 |
||||||||||
|
LIABILITIES + EQUITY |
Earnings Before Interest&Taxes |
734.000 |
|||||||||
|
Short-Term Liabilities |
Interest Expense |
200.000 |
|||||||||
|
Accounts Payable |
660.000 |
520.000 |
Earnings Before Taxes |
534.000 |
|||||||
|
Bank Loan |
550.000 |
1.540.000 |
Tax Expense (40%) |
213.600 |
|||||||
|
Accrued Taxes |
90.000 |
110.000 |
Net Profit After Taxes |
320.400 |
|||||||
|
Long-Term Liabilities |
|||||||||||
|
Bank Loan |
900.000 |
50.000 |
|||||||||
|
Owners’ Equity Common Stocks |
400.000 |
400.000 |
|||||||||
|
Retained Earnings |
900.000 |
1.000.000 |
|||||||||
|
Total Liabilities |
3.500.000 |
3.620.000 |
|||||||||
In: Finance
Sterling Steel Inc. purchased a new stamping machine at the beginning of the year at a cost of $720,000. The estimated residual value was $76,800. Assume that the estimated useful life was five years, and the estimated productive life of the machine was 268,000 units. Actual annual production was as follows: Year Units 1 78,000 2 66,000 3 30,000 4 58,000 5 36,000 Complete a separate depreciation schedule for each of the alternative methods. (Round your answers to the nearest dollar amount. Do not round your intermediate calculations. Omit the "$" sign in your response.) Straight-line. Units-of-production. . Double-declining-balance.
In: Accounting
The E.N.D. partnership has the following capital balances as of the end of the current year:
| Pineda | $ | 310,000 |
| Adams | 270,000 | |
| Fergie | 240,000 | |
| Gomez | 220,000 | |
| Total capital | $ | 1,040,000 |
Answer each of the following independent questions:
Assume that the partners share profits and losses 3:3:2:2, respectively. Fergie retires and is paid $285,000 based on the terms of the original partnership agreement. If the goodwill method is used, what is the capital balance of the remaining three partners?
Assume that the partners share profits and losses 4:3:2:1, respectively. Pineda retires and is paid $365,000 based on the terms of the original partnership agreement. If the bonus method is used, what is the capital balance of the remaining three partners? (Do not round your intermediate calculations. Round your final answers to the nearest dollar amounts.)
In: Accounting