The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):
| 1st Quarter | 2nd Quarter | 3rd Quarter | 4th Quarter | |
| Budgeted unit sales | 11,400 | 12,400 | 14,400 | 13,400 |
The selling price of the company’s product is $13 per unit. Management expects to collect 65% of sales in the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to be uncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in the first quarter, is $71,000.
The company expects to start the first quarter with 1,710 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,910 units.
Required:
1. Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
2. Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
3. Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.
Calculate the estimated sales for each quarter of the fiscal year and for the year as a whole.
|
Calculate the expected cash collections for each quarter of the fiscal year and for the year as a whole.
|
Calculate the required production in units of finished goods for each quarter of the fiscal year and for the year as a whole.
|
In: Accounting
) A public school district is investigating whether to purchase a new school bus to take over the rural-most route in the district. They have two options:
A modern, eco-friendly bus complete with seat belts and air conditioning, will have a first cost of $95,000, cost savings (in terms of fuel efficiency and maintenance costs) of $20,000/year the first year, and decreasing by $1000 per year thereafter (so $19,000 the second year, 18,000 the third year, etc…). It’s estimated that the salvage value will be $8,000 at the end of its 20 year life.
A more basic bus will have a first cost $70,000, cost savings of $14,000 per year decreasing by $500 per year each year thereafter (so $13,500 the second year, $13,000 the third year, etc.).It is estimated that the salvage value will be $5000 at the end of its 20-year life.
Assume that the school district also has the option to stay with their current fleet (so the do nothing option is also available).
A) Use Benefits to Costs analysis to determine which of the options, if any, would be most economical for the school district if their MARR is 5%.
B) Compute the value of X- i.e., the first cost of the modern bus- that makes the two alternatives in this example equally desirable:
|
Modern |
Basic |
|
|
Cost |
X |
$70,000 |
|
Uniform annual benefit |
$20,000 in year 1, decreasing by $1000/year thereafter |
$14,000 in year 1, decreasing by $500/year thereafter |
|
Salvage value |
$8000 |
$5000 |
C) In this problem only the economic consequences were evaluated. Do you think this type of decision is only economic, or are there other factors that could/would/should be considered? Briefly discuss…
(if using excel please post code)
In: Accounting
| Problem 6-9 Short-term versus longer-term borrowing
[LO3] Sauer Food Company has decided to buy a new computer system with an expected life of three years. The cost is $150,000. The company can borrow $150,000 for three years at 10 percent annual interest or for one year at 8 percent annual interest. Assume interest is paid in full at the end of each year. a. How much would Sauer Food Company save in interest over the three-year life of the computer system if the one-year loan is utilized and the loan is rolled over (reborrowed) each year at the same 8 percent rate? Compare this to the 10 percent three-year loan. b. What if interest rates on the 8 percent loan go up to 13 percent in year 2 and 18 percent in year 3? What would be the total interest cost compared to the 10 percent, three-year loan? |
|||||
| Input variables: | |||||
| Number of years | 3 | years | |||
| Cost | $150,000 | ||||
| 3-year Interest rate | 0.10 | ||||
| 1-year interest rate | 0.08 | ||||
| a. Years 2-3 interest rate | 0.08 | ||||
| b. Year 2 interest rate | 0.13 | ||||
| b. Year 3 interest rate | 0.18 | ||||
| Solution and Explanation: | |||||
| a. | |||||
| Interest for 3 years @ | 1-yr rate | ||||
| Interest for 3 years @ | 3-yr rate | ||||
| Interest savings | |||||
| b. | |||||
| Interest for 3 years @ | 3-yr rate | ||||
| Variable rate: | |||||
| Interest - Year 1 | |||||
| Interest - Year 2 | |||||
| Interest - Year 3 | |||||
| Total variable-rate interest | |||||
| Extra interest | |||||
In: Accounting
Yukon Bike Corp. manufactures mountain bikes and distributes them through retail outlets in Canada, Montana, Idaho, Oregon, and Washington. Yukon Bike Corp. declared the following annual dividends over a six-year period ending December 31 of each year: Year 1, $36,000; Year 2, $45,000; Year 3, $72,000; Year 4, $207,000; Year 5, $252,000; and Year 6, $324,000. During the entire period, the outstanding stock of the company was composed of 30,000 shares of 3% preferred stock, $100 par, and 100,000 shares of common stock, $20 par.
Instructions:
1. Determine the total dividends and the per-share dividends declared on each class of stock for each of the six years. If required, round your answers to the nearest cent. If the amount is zero, please enter "0".
| Preferred Dividends | Common Dividends | ||||||||||||||||||||||
| Year | Total Dividends | Total | Per Share | Total | Per Share | ||||||||||||||||||
| Year 1 | $ 36,000 | $ | $ | $ | $ | ||||||||||||||||||
| Year 2 | 45,000 | ||||||||||||||||||||||
| Year 3 | 72,000 | ||||||||||||||||||||||
| Year 4 | 207,000 | ||||||||||||||||||||||
| Year 5 | 252,000 | ||||||||||||||||||||||
| Year 6 | 324,000 | ||||||||||||||||||||||
| $ | $ | ||||||||||||||||||||||
2. Calculate the average annual dividend per share for each class of stock for the six-year period. If required, round your answers to the nearest cent.
| Average annual dividend for preferred: | $ per share |
| Average annual dividend for common: | $ per share |
3. Assuming a market price per share of $210 for the preferred stock and $25 for the common stock, calculate the average annual percentage return on initial shareholders' investment, based on the average annual dividend per share for preferred stock and for common stock.
Round your answers to two decimal places.
| Preferred stock: | % |
| Common stock: | % |
In: Accounting
Please use the following information to answer Question 1-3
You are trying to value LF, a data processing company. The company generated $1 billion in revenues in the most recent financial year and expects revenues to grow 3% per year in perpetuity. It generated $30 million in after-tax operating income in the most recent financial year and expects after-tax operating margin to increase 1% per year starting from the current year (Year 0) to year 3. After year 3, the margin will stabilize at year 3 levels forever. The firm is expected to have depreciation of $ 20 million and capital expenditures of $15 million each year for the next 3 years and to earn a 10% return on capital in perpetuity after that. There are no working capital requirements. The cost of capital will be 12% for the next 3 years and 10% thereafter.
(Hint, we are currently in Year 0 and the After Tax Operating Margin in Year 0 is 3%)
1.Estimate the value of the firm at the end of the third year
(terminal value).
2.Estimate the Present Value of the Terminal Value.
3.Estimate the value of equity per share today, if the firm has
$150 million in debt outstanding, $25 million as a cash balance and
10 million shares.
In: Finance
|
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: |
| Variable costs per unit: | ||
| Manufacturing: | ||
| Direct materials | $ 25 | |
| Direct labor | $ 18 | |
| Variable manufacturing overhead | $ 4 | |
| Variable selling and administrative | $ 3 | |
| Fixed costs per year: | ||
| Fixed manufacturing overhead | $ | 240,000 |
| Fixed selling and administrative expenses | $ | 60,000 |
|
During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of operations, it produced 40,000 units and sold 50,000 units. The selling price of the company’s product is $60 per unit. |
| Required: | |
| 1. | Assume the company uses variable costing: |
| a. | Compute the unit product cost for year 1 and year 2. |
| b. |
Prepare an income statement for year 1 and year 2. |
| 2. | Assume the company uses absorption costing: | |
| a. |
Compute the unit product cost for year 1 and year 2. (Round your answer to 2 decimal places.) |
| b. |
Prepare an income statement for year 1 and year 2. (Round your intermediate calculations to 2 decimal places) |
| 3. |
Reconcile the difference between variable costing and absorption costing net operating income in year 1 and year 2. |
In: Accounting
Over a 4 year period the black corp purchased 100% of the outstanding voting shares of White Co. The acquisition was made in a series of steps as follows:
DATE: % Purchase Price
Jan 1, Year 1 5% 5,000
Jan 1, Year 2 10% 12,000
Jan 1, Year 3 10% 15,000
Jan 1, Year 4 75% 200,000
Total 100% 232,000
Any excess of the purchase price over the net book value of the assets was attributed to goodwill.
The acquisition in Year 3 allowed Black to have significant influence over the operating policies of white.
The acquisition in Year 4 gave Black control over White.
Operating results, dividends paid and fair value of white for the 4 years were as follows:
Net Income Dividend Paid Fair Value
Jan 1 Year 1 100,000
Year 1 25,000 15,000 120,000
Year 2 30,000 15,000 150,000
Year 3 40,000 20,000 170,000
Year 4 50,000 25,000 250,000
For each of the 4 years compute the amount of income that will be recorded on Black’s books related to its investment in White Co. AND compute the balance in “Investment in White Co. Account” on Blacks books at December, 31 of each year
*SHOW ALL WORK*
In: Accounting
Danube recently acquired a delivery van for $24,200 paying cash. Danube projects a 4 year useful service life and a remaining residual value on the delivery van of $2,200. Danube expects to drive the van 106,000 miles during the useful service life. Please compute the annual depreciation for the 4 year life of the delivery van for each of these methods:
1. Straight-line
Depreciation expense
2. Double-declining-balance. (Round your depreciation rate to 2 decimal places. Round your final answers to the nearest whole dollar.) End year ammounts. Years 1,2,3, with depreciation expense, accumulated depreciation and book value for each year.
3. Actual miles driven each year were 19,000 miles in Year 1; 29,000 miles in Year 2; 23,000 miles in Year 3; and 25,000 miles in Year 4. Note that actual total miles of 96,000 fall short of expectations by 10,000 miles. Calculate annual depreciation for the four-year life of the van using activity-based. (Round your depreciation rate to 2 decimal places.) end of year amounts year 1, 2, 3, 4, with depreciation expense, accumulated depreciation and book value for each year.
In: Accounting
Jasper and Crewella Dahvill were married in year 0. They filed joint tax returns in years 1 and 2. In year 3, their relationship was strained and Jasper insisted on filing a separate tax return. In year 4, the couple divorced. Both Jasper and Crewella filed single tax returns in year 4. In year 5, the IRS audited the couple’s joint year 2 tax return and each spouse’s separate year 3 tax returns. The IRS determined that the year 2 joint return and Crewella’s separate year 3 tax return understated Crewella’s self-employment income, causing the joint return year 2 tax liability to be understated by $5,800 and Crewella’s year 3 separate return tax liability to be understated by $8,450. The IRS also assessed penalties and interest on both of these tax returns. Try as it might, the IRS has not been able to locate Crewella, but they have been able to find Jasper. (Leave no answer blank. Enter 0 if applicable.)
Problem 4-52 Part-a (Algo)
a. What is the maximum amount of tax that the IRS can require Jasper to pay for the Dahvill’s year 2 joint return?
b. What is the maximum amount of tax that the IRS can require Jasper to pay for Crewella’s year 3 separate tax return?
In: Accounting
|
Walsh Company manufactures and sells one product. The following information pertains to each of the company’s first two years of operations: |
| Variable costs per unit: | ||
| Manufacturing: | ||
| Direct materials | $ 30 | |
| Direct labor | $ 17 | |
| Variable manufacturing overhead | $ 2 | |
| Variable selling and administrative | $ 1 | |
| Fixed costs per year: | ||
| Fixed manufacturing overhead | $ | 320,000 |
| Fixed selling and administrative expenses | $ | 80,000 |
|
During its first year of operations, Walsh produced 50,000 units and sold 40,000 units. During its second year of operations, it produced 40,000 units and sold 50,000 units. The selling price of the company’s product is $53 per unit. |
| Required: | |
| 1. | Assume the company uses variable costing: |
| a. | Compute the unit product cost for year 1 and year 2. |
| b. |
Prepare an income statement for year 1 and year 2. |
| 2. | Assume the company uses absorption costing: | |
| a. |
Compute the unit product cost for year 1 and year 2. (Round your answer to 2 decimal places.) |
| b. |
Prepare an income statement for year 1 and year 2. (Round your intermediate calculations to 2 decimal places) |
| 3. |
Reconcile the difference between variable costing and absorption costing net operating income in year 1 and year 2. |
In: Accounting