Horizontal Analysis of the Income Statement
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $496,100 | $410,000 | |||
| Cost of goods sold | 413,000 | 350,000 | |||
| Gross profit | $83,100 | $60,000 | |||
| Selling expenses | $23,310 | $21,000 | |||
| Administrative expenses | 20,230 | 17,000 | |||
| Total operating expenses | $43,540 | $38,000 | |||
| Income before income tax | $39,560 | $22,000 | |||
| Income tax expenses | 15,800 | 8,800 | |||
| Net income | $23,760 | $13,200 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Winthrop Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount |
Previous year Amount |
Increase (Decrease) Amount |
Increase (Decrease) Percent |
|
| Sales | $496,100 | $410,000 | $ | % |
| Cost of goods sold | 413,000 | 350,000 | % | |
| Gross profit | $83,100 | $60,000 | $ | % |
| Selling expenses | $23,310 | $21,000 | $ | % |
| Administrative expenses | 20,230 | 17,000 | % | |
| Total operating expenses | $43,540 | $38,000 | $ | % |
| Income before income tax | $39,560 | $22,000 | $ | % |
| Income tax expense | 15,800 | 8,800 | % | |
| Net income | $23,760 | $13,200 | $ | % |
b. The net income for Winthrop Company increased between years. This increase was the combined result of an in sales and percentage in cost of goods sold. The cost of goods sold increased at a rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
Horizontal Analysis of the Income Statement
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $864,000 | $720,000 | |||
| Cost of goods sold | 731,600 | 620,000 | |||
| Gross profit | $132,400 | $100,000 | |||
| Selling expenses | $36,300 | $33,000 | |||
| Administrative expenses | 33,040 | 28,000 | |||
| Total operating expenses | $69,340 | $61,000 | |||
| Income before income tax | $63,060 | $39,000 | |||
| Income tax expenses | 25,200 | 15,600 | |||
| Net income | $37,860 | $23,400 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Winthrop Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount |
Previous year Amount |
Increase (Decrease) Amount |
Increase (Decrease) Percent |
|
| Sales | $864,000 | $720,000 | $ | % |
| Cost of goods sold | 731,600 | 620,000 | % | |
| Gross profit | $132,400 | $100,000 | $ | % |
| Selling expenses | $36,300 | $33,000 | $ | % |
| Administrative expenses | 33,040 | 28,000 | % | |
| Total operating expenses | $69,340 | $61,000 | $ | % |
| Income before income tax | $63,060 | $39,000 | $ | % |
| Income tax expense | 25,200 | 15,600 | % | |
| Net income | $37,860 | $23,400 | $ | % |
b. The net income for Winthrop Company increased between years. This increase was the combined result of an in sales and percentage in cost of goods sold. The cost of goods sold increased at a rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
Horizontal Analysis of the Income Statement
Income statement data for Boone Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $488,000 | $400,000 | |||
| Cost of goods sold | 420,000 | 350,000 | |||
| Gross profit | $68,000 | $50,000 | |||
| Selling expenses | $19,040 | $17,000 | |||
| Administrative expenses | 16,800 | 14,000 | |||
| Total operating expenses | $35,840 | $31,000 | |||
| Income before income tax | $32,160 | $19,000 | |||
| Income tax expenses | 12,900 | 7,600 | |||
| Net income | $19,260 | $11,400 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Boone Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount | Previous year Amount | Increase (Decrease) Amount | Increase (Decrease) Percent | |
| Sales | $488,000 | $400,000 | $ | % |
| Cost of goods sold | 420,000 | 350,000 | % | |
| Gross profit | $68,000 | $50,000 | $ | % |
| Selling expenses | 19,040 | 17,000 | % | |
| Administrative expenses | 16,800 | 14,000 | % | |
| Total operating expenses | $35,840 | $31,000 | $ | % |
| Income before income tax | $32,160 | $19,000 | $ | % |
| Income tax expense | 12,900 | 7,600 | % | |
| Net income | $19,260 | $11,400 | $ | % |
b. The net income for Boone Company increased by 68.9% between years. This increase was the combined result of an in sales of 22% and percentage in cost of goods sold. The cost of goods sold increased at a rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $372,000 | $310,000 | |||
| Cost of goods sold | 318,600 | 270,000 | |||
| Gross profit | $53,400 | $40,000 | |||
| Selling expenses | $14,300 | $13,000 | |||
| Administrative expenses | 12,980 | 11,000 | |||
| Total operating expenses | $27,280 | $24,000 | |||
| Income before income tax | $26,120 | $16,000 | |||
| Income tax expenses | 10,400 | 6,400 | |||
| Net income | $15,720 | $9,600 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Winthrop Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount |
Previous year Amount |
Increase (Decrease) Amount |
Increase (Decrease) Percent |
|
| Sales | $372,000 | $310,000 | $ | % |
| Cost of goods sold | 318,600 | 270,000 | % | |
| Gross profit | $53,400 | $40,000 | $ | % |
| Selling expenses | $14,300 | $13,000 | $ | % |
| Administrative expenses | 12,980 | 11,000 | % | |
| Total operating expenses | $27,280 | $24,000 | $ | % |
| Income before income tax | $26,120 | $16,000 | $ | % |
| Income tax expense | 10,400 | 6,400 | % | |
| Net income | $15,720 | $9,600 | $ | % |
b. The net income for Winthrop Company increased between years. This increase was the combined result of an in sales and percentage in cost of goods sold. The cost of goods sold increased at a rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $458,500 | $350,000 | |||
| Cost of goods sold | 384,000 | 300,000 | |||
| Gross profit | $74,500 | $50,000 | |||
| Selling expenses | $22,990 | $19,000 | |||
| Administrative expenses | 20,640 | 16,000 | |||
| Total operating expenses | $43,630 | $35,000 | |||
| Income before income tax | $30,870 | $15,000 | |||
| Income tax expenses | 12,300 | 6,000 | |||
| Net income | $18,570 | $9,000 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Winthrop Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount |
Previous year Amount |
Increase (Decrease) Amount |
Increase (Decrease) Percent |
|
| Sales | $458,500 | $350,000 | $ | % |
| Cost of goods sold | 384,000 | 300,000 | % | |
| Gross profit | $74,500 | $50,000 | $ | % |
| Selling expenses | $22,990 | $19,000 | $ | % |
| Administrative expenses | 20,640 | 16,000 | % | |
| Total operating expenses | $43,630 | $35,000 | $ | % |
| Income before income tax | $30,870 | $15,000 | $ | % |
| Income tax expense | 12,300 | 6,000 | % | |
| Net income | $18,570 | $9,000 | $ | % |
b. The net income for Winthrop Company increased between years. This increase was the combined result of an in sales and percentage in cost of goods sold. The cost of goods sold increased at a rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
Horizontal Analysis of the Income Statement
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $725,000 | $580,000 | |||
| Cost of goods sold | 597,800 | 490,000 | |||
| Gross profit | $127,200 | $90,000 | |||
| Selling expenses | $36,800 | $32,000 | |||
| Administrative expenses | 33,210 | 27,000 | |||
| Total operating expenses | $70,010 | $59,000 | |||
| Income before income tax | $57,190 | $31,000 | |||
| Income tax expenses | 22,900 | 12,400 | |||
| Net income | $34,290 | $18,600 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Winthrop Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount |
Previous year Amount |
Increase (Decrease) Amount |
Increase (Decrease) Percent |
|
| Sales | $725,000 | $580,000 | $ | % |
| Cost of goods sold | 597,800 | 490,000 | % | |
| Gross profit | $127,200 | $90,000 | $ | % |
| Selling expenses | 36,800 | 32,000 | % | |
| Administrative expenses | 33,210 | 27,000 | % | |
| Total operating expenses | $70,010 | $59,000 | $ | % |
| Income before income tax | $57,190 | $31,000 | $ | % |
| Income tax expense | 22,900 | 12,400 | % | |
| Net income | $34,290 | $18,600 | $ | % |
b. The net income for Winthrop Company increased by 84.4% between years. This increase was the combined result of an in sales of 25% and percentage in cost of goods sold. The cost of goods sold increased at a rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
Horizontal Analysis of the Income Statement
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $736,600 | $580,000 | |||
| Cost of goods sold | 607,600 | 490,000 | |||
| Gross profit | $129,000 | $90,000 | |||
| Selling expenses | $37,440 | $32,000 | |||
| Administrative expenses | 33,750 | 27,000 | |||
| Total operating expenses | $71,190 | $59,000 | |||
| Income before income tax | $57,810 | $31,000 | |||
| Income tax expenses | 23,100 | 12,400 | |||
| Net income | $34,710 | $18,600 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Winthrop Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount |
Previous year Amount |
Increase (Decrease) Amount |
Increase (Decrease) Percent |
|
| Sales | $736,600 | $580,000 | $ | % |
| Cost of goods sold | 607,600 | 490,000 | % | |
| Gross profit | $129,000 | $90,000 | $ | % |
| Selling expenses | $37,440 | $32,000 | $ | % |
| Administrative expenses | 33,750 | 27,000 | % | |
| Total operating expenses | $71,190 | $59,000 | $ | % |
| Income before income tax | $57,810 | $31,000 | $ | % |
| Income tax expense | 23,100 | 12,400 | % | |
| Net income | $34,710 | $18,600 | $ | % |
b. The net income for Winthrop Company increased between years. This increase was the combined result of an ___ in sales and percentage ____ in cost of goods sold. The cost of goods sold increased at a ___ rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
Horizontal Analysis of the Income Statement
Income statement data for Winthrop Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $701,100 | $570,000 | |||
| Cost of goods sold | 605,000 | 500,000 | |||
| Gross profit | $96,100 | $70,000 | |||
| Selling expenses | $27,120 | $24,000 | |||
| Administrative expenses | 24,200 | 20,000 | |||
| Total operating expenses | $51,320 | $44,000 | |||
| Income before income tax | $44,780 | $26,000 | |||
| Income tax expenses | 17,900 | 10,400 | |||
| Net income | $26,880 | $15,600 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Winthrop Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount |
Previous year Amount |
Increase (Decrease) Amount |
Increase (Decrease) Percent |
|
| Sales | $701,100 | $570,000 | $ | % |
| Cost of goods sold | 605,000 | 500,000 | % | |
| Gross profit | $96,100 | $70,000 | $ | % |
| Selling expenses | $27,120 | $24,000 | $ | % |
| Administrative expenses | 24,200 | 20,000 | % | |
| Total operating expenses | $51,320 | $44,000 | $ | % |
| Income before income tax | $44,780 | $26,000 | $ | % |
| Income tax expense | 17,900 | 10,400 | % | |
| Net income | $26,880 | $15,600 | $ | % |
b. The net income for Winthrop Company increased between years. This increase was the combined result of an in sales and percentage in cost of goods sold. The cost of goods sold increased at a rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
Horizontal Analysis of the Income Statement
Income statement data for Boone Company for two recent years ended December 31, are as follows:
| Current Year | Previous Year | ||||
| Sales | $486,400 | $380,000 | |||
| Cost of goods sold | 415,800 | 330,000 | |||
| Gross profit | $70,600 | $50,000 | |||
| Selling expenses | $21,240 | $18,000 | |||
| Administrative expenses | 18,900 | 15,000 | |||
| Total operating expenses | $40,140 | $33,000 | |||
| Income before income tax | $30,460 | $17,000 | |||
| Income tax expenses | 12,200 | 6,800 | |||
| Net income | $18,260 | $10,200 | |||
a. Prepare a comparative income statement with horizontal analysis, indicating the increase (decrease) for the current year when compared with the previous year. If required, round to one decimal place.
| Boone Company | ||||
| Comparative Income Statement | ||||
| For the Years Ended December 31 | ||||
| Current year Amount | Previous year Amount | Increase (Decrease) Amount | Increase (Decrease) Percent | |
| Sales | $486,400 | $380,000 | $ | % |
| Cost of goods sold | 415,800 | 330,000 | % | |
| Gross profit | $70,600 | $50,000 | $ | % |
| Selling expenses | 21,240 | 18,000 | % | |
| Administrative expenses | 18,900 | 15,000 | % | |
| Total operating expenses | $40,140 | $33,000 | $ | % |
| Income before income tax | $30,460 | $17,000 | $ | % |
| Income tax expense | 12,200 | 6,800 | % | |
| Net income | $18,260 | $10,200 | $ | % |
b. The net income for Boone Company increased by 79% between years. This increase was the combined result of an in sales of 28% and percentage in cost of goods sold. The cost of goods sold increased at a rate than the increase in sales, thus causing the percentage increase in gross profit to be than the percentage increase in sales.
In: Accounting
After analysing the financial data of Q-Constructions, you notice that they are trending in the right direction. A new 12-month construction proposal has come to the company worth $1,000,000 and an important question is whether it will be financially viable. They want you to analyse the proposal, in particular, the recommended cash flow schedule and to understand the key financial points during the construction project. The following cash flow schedule is summarised below.
To ensure that all upfront and on-going outlay costs are covered
in advance, Q-Constructions incur an initial start-up cost of
$200,000. The proposal states that they will receive a deposit from
the client of 10% of the total project price at the beginning. They
then receive four equal instalment payments of 20% of the total
project price associated to project milestones from the client at
the end of the 2nd, 6th, 8th and 10th month. Finally, they receive
the last 10% project milestone on lock-up which occurs at the end
of the 12th month. Q-Constructions has ongoing project costs of
$20,000 to pay salaries and services at the end of each month. In
additional, there are material costs of $100,000 associated for
each of the project milestones at the end of the 2nd, 6th, 8th and
10th month. The current cost of capital for company is 8% per annum
compounded monthly. You have been tasked with the important
objective to determine whether this future project is financially
viable. In addition, they want you to determine which milestone is
needed to be completed in the project proposal such that it will be
financially viable. It’s time to show your Quants knowledge and
expertise with Excel to determine the financial viability of this
project.
(a) In a worst-case scenario where the
project does not proceed, and the initial outlay is paid. Calculate
the amount of interest that would have accrued on an amount of
$200,000 at the end of 12 months with an interest rate of 8% p.a
compounded monthly. Do not use EXCEL for this calculation.
(b) Set up a cash inflow and outflow for the
12-month construction project proposal based on the information
provided by the company above. By using the current 8% p.a
compounded monthly cost of capital, calculate the Net Present Value
of this proposal and whether it is financially viable project. Use
EXCEL to calculate the net present value of the current
situation.
In: Finance