Income Statement
Pietro Frozen Foods, Inc., produces frozen pizzas. For next year, Pietro predicts that 53,100 units will be produced, with the following total costs:
| Direct materials | ? |
| Direct labor | 55,000 |
| Variable overhead | 28,000 |
| Fixed overhead | 245,000 |
Next year, Pietro expects to purchase $119,500 of direct materials. Projected beginning and ending inventories for direct materials and work in process are as follows:
| Direct materials Inventory |
Work-in-Process Inventory |
|
| Beginning | $6,000 | $12,500 |
| Ending | $5,900 | $14,500 |
Next year, Pietro expects to produce 53,100 units and sell 52,400 units at a price of $15.00 each. Beginning inventory of finished goods is $39,500, and ending inventory of finished goods is expected to be $31,000. Total selling expense is projected at $27,500, and total administrative expense is projected at $126,000.
Required:
1. Prepare an income statement in good form. Round the percent to four decimal places before converting to a percentage. For example, .88349 would be rounded to .8835 and entered as 88.35.
| Pietro Frozen Foods, Inc. | |||
| Income Statement | |||
| For the Coming Year | |||
| Percent | |||
|
$ | % | |
|
% | ||
|
$ | % | |
| Less operating expenses: | |||
|
$ | ||
|
% | ||
|
$ | % | |
2. What if the cost of goods sold percentage for the past few years was 54.77 percent? Management's reaction might be:
In: Accounting
Feathered FriendsFeathered Friends makes backyard birdfeeders. The company sells the birdfeeders to home improvement stores for $12 per birdfeeder. Each birdfeeder requires 3.0 board feet of wood, which the company obtains at a cost of $2 per board foot. The company would like to maintain an ending stock of wood equal to 10% of the next month's production requirements. The company would also like to maintain an ending stock of finished birdfeeders equal to 25% of the next month's sales. Sales data for the company is as follows:
|
Units |
|
|
October actual sales (prior year). . . . . . . . |
96,000 |
|
November actual sales (prior year). . . . . . |
89,000 |
|
December actual sales (prior year). . . . . . |
80,000 |
|
January projected sales. . . . . . . . . . . . . |
76,000 |
|
February projected sales. . . . . . . . . . . . . . |
86,000 |
|
March projected sales. . . . . . . . . . . . . . . . . |
97,000 |
|
April projected sales. . . . . . . . . . . . . . . . . . |
110,000 |
| In any given month,
20% of the total sales are cash sales, while the remainder are credit sales. |
| The company's collection history indicates that 60 % of credit sales is collected in the month after the sale, 30% is collected two months after the sale, 5% is collected three months after the sale, and the remaining 5% is never collected. |
|
Assume that the total cost of direct materials purchases in
December was $520,000. The company pays 60% |
Prepare the direct materials purchases budget for the first three months of the year, as well as a summary budget for the quarter. Assume the company needs 105,000
board feet of wood for production in April. (Round your answers to the nearest whole dollar.)
|
Feathered Friends |
|||||
|
Direct Materials Budget |
|||||
|
For the Quarter Ended March 31 |
|||||
|
January |
February |
March |
Quarter |
|
|
Units to be produced |
||||
|
Multiply by: Quantity (board feet) of DM needed per unit |
||||
|
Quantity (board feet) needed for production |
||||
|
Plus: Desired ending inventory of DM |
||||
|
Total quantity (board feet) needed |
||||
|
Less: Beginning inventory of DM |
||||
|
Quantity (board feet) to purchase |
||||
|
Multiply by: Cost per board foot |
||||
|
Total cost of DM purchases |
In: Accounting
During 2020, Skysong Furniture Company purchases a carload of
wicker chairs. The manufacturer sells the chairs to Skysong for a
lump sum of $77,805 because it is discontinuing manufacturing
operations and wishes to dispose of its entire stock. Three types
of chairs are included in the carload. The three types and the
estimated selling price for each are listed below.
|
Type |
No. of Chairs |
Estimated Selling |
|||
|---|---|---|---|---|---|
|
Lounge chairs |
520 | $90 | |||
|
Armchairs |
390 | 80 | |||
|
Straight chairs |
910 | 50 | |||
During 2020, Skysong sells 260 lounge chairs, 130 armchairs, and
156 straight chairs.
What is the amount of gross profit realized during 2020? What is
the amount of inventory of unsold straight chairs on December 31,
2020? (Round cost per chair to 2 decimal places, e.g.
78.25 and final answer to 0 decimal places, e.g.
5,845.)
|
Gross profit realized during 2020 |
$enter a dollar amount |
|
|---|---|---|
|
Amount of inventory of unsold straight chairs |
$enter a dollar amount |
In: Accounting
olvency Analysis
The following information is available from the balance sheets
at the ends of the two most recent years and the income statement
for the most recent year of Impact Company:
| December 31 | ||||||
| 2017 | 2016 | |||||
| Accounts payable | $ 65,000 | $ 50,000 | ||||
| Accrued liabilities | 25,000 | 35,000 | ||||
| Taxes payable | 60,000 | 45,000 | ||||
| Short-term notes payable | 0 | 75,000 | ||||
| Bonds payable due within next year | 200,000 | 200,000 | ||||
| Total current liabilities | $ 350,000 | $ 405,000 | ||||
| Bonds payable | $ 600,000 | $ 800,000 | ||||
| Common stock, $10 par | $1,000,000 | $1,000,000 | ||||
| Retained earnings | 650,000 | 500,000 | ||||
| Total stockholders’ equity | $1,650,000 | $1,500,000 | ||||
| Total liabilities and stockholders’ equity | $2,600,000 | $2,705,000 | ||||
| 2017 | ||
| Sales revenue | $1,600,000 | |
| Cost of goods sold | 950,000 | |
| Gross profit | $ 650,000 | |
| Selling and administrative expense | 300,000 | |
| Operating income | $ 350,000 | |
| Interest expense | 89,000 | |
| Income before tax | $ 261,000 | |
| Income tax expense | 111,000 | |
| Net income | $ 150,000 |
Other Information:
Required:
1. Compute the following for Impact Company. Round your answers to two decimal places.
| 2017 | 2016 | |||
| a. The debt-to-equity ratio at December 31, 2017, and December 31, 2016 | to 1 | to 1 | ||
| b. The times interest earned ratio for 2017 | to 1 | |||
| c. The debt service coverage ratio for 2017 | times | |||
In: Accounting
Based on your work experience or reading of the chapter, briefly describe how an ERP can connect and integrate the cycles of a business (e.g., revenue-expenditure cycles, revenue-payroll cycles, and etc)
In: Accounting
Question 2 Active PLC is a leading investment company in Australia and you the below details relating to the capital structure of the company. Information concerning raising new capital Bonds $1,000 Face value 13% Coupon Rate (Annual Payments) 20 Term (Years) $25 Discount offered (required) to sell new bonds $10 Flotation Cost per bond Preference Shares 11% Required rate to sell new preference shares $100 Face Value $3 Flotation cost per share Ordinary Shares $83.33 Current Market Price $4.00 Discount on share price to sell new shares $5.40 Flotation Cost per bond $5.00 2019 - Proposed Dividend Dividend History $4.63 2019 $4.29 2018 $3.97 2017 $3.68 2016 $3.40 2015 Current Capital Structure Extract from Balance Sheet $1,000,000 Long-Term Debt $800,000 Preference Shares $2,000,000 Ordinary Shares Current Market Values $2,000,000 Long-Term Debt $750,000 Preference Shares $4,000,000 Ordinary Shares Tax Rate 33% Risk Free Rate 5% 3 a) Calculate the cost associated with each new source of finance. The firm has no retained earnings available. b) Calculate the WACC given the existing weights The financial controller does not believe the existing capital structure weights are appropriate to minimise the firm’s cost of capital in the medium term and believes they should be as follows Long-term debt 40% Preference Shares 15% Ordinary Shares 45% c) What impact do these new weights have on the WACC? The firm is considering the following investment opportunity. (2020-2027) Data is as follows Initial Outlay $1,600,000 Upgrade $700,000 End of Year 4 Upgrade - 350,000 Increased sales units per annum - (Year 5-8) Working Capital $45,000 Increase required Estimated Life 8 Years Salvage Value $60,000 Depreciation Rate 0.125 For tax purposes The machine is fully depreciated by the end of its useful life Other Cash Expenses $60,000.00 Per annum (Years 1-4) Other Cash Expenses $76,000.00 Per annum (Years 5-8) Production Costs $0.15 Per Unit Sales price $0.75 Per Unit (Years 1-4) Sales price $1.02 Per Unit (Years 5-8) 4 Prior sales estimates Year Sales 2010 520000 2011 530000 2012 540000 2013 560000 2014 565000 2015 590000 2016 600000 2017 610000 2018 615559 2019 659000 2020 680000 d) Calculate the Net Present Value, Internal Rate of Return and Payback Period The financial controller is considering the use of the Capital Asset Pricing Model as a surrogate discount factor. The risk-free rate is 5 per cent. Year Stock Market Share Index Price 2010 2000 $15.00 2011 2400 $25.00 2012 2900 $33.00 2013 3500 $40.00 2014 4200 $45.00 2015 5000 $55.00 2016 5900 $62.00 2017 6000 $68.00 2018 6100 $74.00 2019 6200 $80.00 2020 6300 $83.33 e) Calculate the CAPM f) Explain why this figure may differ from that calculated above (i.e. Cost of equity – Ordinary Shares)
In: Accounting
explain the situations that are related to the transfer of products between divisions located in different countries. illustration 8B-1 from your textbook, Weygandt, Kimmel, & Kieso (2015, p. 337). What conclusion can you come to after analyzing the data in Illustration 8B-1? There, a company's after-tax contribution margins are compared using a unit transfer price of $ 18.00 versus a unit transfer price of $ 11.00 (Weygandt, Kimmel, & Kieso, 2015, p. 337).
In: Accounting
Maddow and Wells, Inc. purchased equity securities in 2018. The management of the company has decided that the securities will not be sold immediately, but will be held for at least three years. This will allow MW to maximize the potential gains from holding the securities. The new accountant at the company wants to classify the securities as held-to-maturity because they will be held for three years; the company has never held securities for this long before. How would you advise the management of the company to classify the securities? At the end of each reporting year, how will the securities be recognized on the company’s books? Support your response with an appropriate ASC reference (ASC xxx-xx-xx-x) or ASU (accounting standard update).
In: Accounting
In: Accounting
On June 30, 2018, Blue, Inc. leased a machine from Big Leasing Corporation. The lease agreement qualifies as a capital lease and calls for Blue to make semiannual lease payments of $286,143 over a three-year lease term, payable each June 30 and December 31, with the first payment at June 30, 2018. Blue’s incremental borrowing rate is 8%, the same rate Big uses to calculate lease payment amounts. The lease agreement qualifies as a finance lease. Amortization is recorded on a straight-line basis at the end of each year. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and PVAD of $1) (Use appropriate factor(s) from the tables provided.) Required: 1. Determine the present value of the lease payments at June 30, 2018, (to the nearest $000) that Blue uses to record the right-of-use asset and lease liability. 2. What would be the amounts related to the lease that Blue would report in its balance sheet at December 31, 2018? (Ignore taxes.) 3. What would be the amounts related to the lease that Blue would report in its income statement for the year ended December 31, 2018? (Ignore taxes.) (For all requirements, round your answers to the nearest whole dollar amounts.)
In: Accounting
Wells Technical Institute (WTI), a school owned by Tristana Wells, provides training to individuals who pay tuition directly to the school. WTI also offers training to groups in off-site locations. Its unadjusted trial balance as of December 31, 2017, follows. WTI initially records prepaid expenses and unearned revenues in balance sheet accounts. Descriptions of items a through h that require adjusting entries on December 31, 2017, follow. Additional Information Items An analysis of WTI's insurance policies shows that $2,674 of coverage has expired. An inventory count shows that teaching supplies costing $2,318 are available at year-end 2017. Annual depreciation on the equipment is $10,698. Annual depreciation on the professional library is $5,349. On November 1, WTI agreed to do a special six-month course (starting immediately) for a client. The contract calls for a monthly fee of $2,700, and the client paid the first five months' fees in advance. When the cash was received, the Unearned Training Fees account was credited. The fee for the sixth month will be recorded when it is collected in 2018. On October 15, WTI agreed to teach a four-month class (beginning immediately) for an individual for $2,561 tuition per month payable at the end of the class. The class started on October 15, but no payment has yet been received. (WTI's accruals are applied to the nearest half-month; for example, October recognizes one-half month accrual.) WTI's two employees are paid weekly. As of the end of the year, two days' salaries have accrued at the rate of $100 per day for each employee. The balance in the Prepaid Rent account represents rent for December.
|
WELLS TECHNICAL INSTITUTE Unadjusted Trial Balance December 31, 2017 |
|||||
| Debit | Credit | ||||
| Cash | $ | 27,396 | |||
| Accounts receivable | 0 | ||||
| Teaching supplies | 10,536 | ||||
| Prepaid insurance | 15,806 | ||||
| Prepaid rent | 2,108 | ||||
| Professional library | 31,610 | ||||
| Accumulated depreciation—Professional library | $ | 9,484 | |||
| Equipment | 73,751 | ||||
| Accumulated depreciation—Equipment | 16,861 | ||||
| Accounts payable | 36,022 | ||||
| Salaries payable | 0 | ||||
| Unearned training fees | 13,500 | ||||
| Common stock | 10,000 | ||||
| Retained earnings | 57,016 | ||||
| Dividends | 42,149 | ||||
| Tuition fees earned | 107,477 | ||||
| Training fees earned | 40,040 | ||||
| Depreciation expense—Professional library | 0 | ||||
| Depreciation expense—Equipment | 0 | ||||
| Salaries expense | 50,579 | ||||
| Insurance expense | 0 | ||||
| Rent expense | 23,188 | ||||
| Teaching supplies expense | 0 | ||||
| Advertising expense | 7,376 | ||||
| Utilities expense | 5,901 | ||||
| Totals | $ | 290,400 | $ |
290,400 |
|
Help!
I just need to know how to get the (f)
f. account receivable
tuition fees earned
pls explain
In: Accounting
In: Accounting
| Units sold | 1,180 | ||
| Price | $ | 10 | |
| Sales | $ | 11,800 | |
| Variable manufacturing costs | 4,720 | ||
| Fixed manufacturing costs | 2,360 | ||
| Variable selling costs | 1,180 | ||
| Fixed administrative costs | 1,180 | ||
Required:
Using the data provided, compute the margin of safety and margin of safety ratio.
mos:
mos ratio:
In: Accounting
Craig owns a home with a replacement cost of $200,000 that is subject to a $100,000 mortgage held by First Federal as the mortgagee. Craig has the home insured for $160,000 under the HO-3 policy, and First Federal is named as mortgagee under the Mortgage Clause. Assume there is a covered fire loss to the dwelling in the amount of $50,000. To whom would the loss be paid?
In: Accounting
Hyrkas Corporation's most recent balance sheet and income statement appear below:
|
Balance Sheet |
||||||
|
December 31, Year 2 and Year 1 |
||||||
|
(in thousands of dollars) |
||||||
|
Year 2 |
Year 1 |
|||||
|
Assets |
||||||
|
Current assets: |
||||||
|
Cash |
$ |
180 |
$ |
250 |
||
|
Accounts receivable, net |
280 |
300 |
||||
|
Inventory |
250 |
220 |
||||
|
Prepaid expenses |
20 |
20 |
||||
|
Total current assets |
730 |
790 |
||||
|
Plant and equipment, net |
940 |
980 |
||||
|
Total assets |
$ |
1,670 |
$ |
1,770 |
||
|
Liabilities and Stockholders' Equity |
||||||
|
Current liabilities: |
||||||
|
Accounts payable |
$ |
220 |
$ |
250 |
||
|
Accrued liabilities |
50 |
50 |
||||
|
Notes payable, short term |
40 |
40 |
||||
|
Total current liabilities |
310 |
340 |
||||
|
Bonds payable |
210 |
300 |
||||
|
Total liabilities |
520 |
640 |
||||
|
Stockholders’ equity: |
||||||
|
Common stock, $2 par value |
200 |
200 |
||||
|
Additional paid-in capital |
330 |
330 |
||||
|
Retained earnings |
620 |
600 |
||||
|
Total stockholders’ equity |
1,150 |
1,130 |
||||
|
Total liabilities & stockholders’ equity |
$ |
1,670 |
$ |
1,770 |
||
|
Income Statement |
|||
|
For the Year Ended December 31, Year 2 |
|||
|
(in thousands of dollars) |
|||
|
Sales (all on account) |
$ |
1,320 |
|
|
Cost of goods sold |
820 |
||
|
Gross margin |
500 |
||
|
Selling and administrative expense |
395 |
||
|
Net operating income |
105 |
||
|
Interest expense |
20 |
||
|
Net income before taxes |
85 |
||
|
Income taxes (30%) |
26 |
||
|
Net income |
$ |
59 |
|
Dividends on common stock during Year 2 totaled $39 thousand. The market price of common stock at the end of Year 2 was $14.40 per share.
Required:
Compute the following for Year 2:
a. Gross margin percentage. (Round your answer to 1 decimal place.)
b. Earnings per share. (Round your answer to 2 decimal places.)
c. Price-earnings ratio. (Do not round intermediate calculations. Round your answer to 1 decimal place.)
d. Dividend payout ratio. (Do not round intermediate calculations. Round your "Percentage" answer to 1 decimal place.)
e. Dividend yield ratio. (Round your "Percentage" answer to 2 decimal places.)
f. Return on total assets. (Do not round intermediate calculations. Round your "Percentage" answer to 2 decimal places.)
g. Return on equity. (Round your "Percentage" answer to 2 decimal places.)
h. Book value per share. (Round your answer to 2 decimal places.)
i. Working capital. (Input your answer in thousands of dollars.)
j. Current ratio. (Round your answer to 2 decimal places.)
k. Acid-test (quick) ratio. (Round your answer to 2 decimal places.)
l. Accounts receivable turnover. (Round your answer to 2 decimal places.)
m. Average collection period. (Use 365 days in a year. Do not round intermediate calculations. Round your answer to 1 decimal place.)
n. Inventory turnover. (Round your answer to 2 decimal places.)
o. Average sale period. (Use 365 days in a year. Do not round intermediate calculations. Round your answer to 1 decimal place.)
p. Times interest earned ratio. (Round your answer to 2 decimal places.)
q. Debt-to-equity ratio. (Round your answer to 2 decimal places.)
In: Accounting