Waterways Corporation is preparing its budget for the coming
year, 2020. The first step is to plan for the first quarter of that
coming year. The company has gathered information from its managers
in preparation of the budgeting process.
| Sales | ||
| Unit sales for November 2019 | 112,000 | |
| Unit sales for December 2019 | 101,000 | |
| Expected unit sales for January 2020 | 114,000 | |
| Expected unit sales for February 2020 | 112,000 | |
| Expected unit sales for March 2020 | 115,000 | |
| Expected unit sales for April 2020 | 127,000 | |
| Expected unit sales for May 2020 | 136,000 | |
| Unit selling price | $12 |
Waterways likes to keep 10% of the next month’s unit sales in
ending inventory. All sales are on account. 85% of the Accounts
Receivable are collected in the month of sale, and 15% of the
Accounts Receivable are collected in the month after sale. Accounts
receivable on December 31, 2019, totaled $181,800.
Direct Materials
Direct materials cost 80 cents per pound. Two pounds of direct
materials are required to produce each unit.
Waterways likes to keep 5% of the materials needed for the next
month in its ending inventory. Raw Materials on December 31, 2019,
totaled 11,380 pounds. Payment for materials is made within 15
days. 50% is paid in the month of purchase, and 50% is paid in the
month after purchase. Accounts Payable on December 31, 2019,
totaled $102,875.
| Direct Labor |
| Labor requires 12 minutes per unit for completion and is paid at a rate of $9 per hour. |
| Manufacturing Overhead | ||||
| Indirect materials | 30¢ | per labor hour | ||
| Indirect labor | 50¢ | per labor hour | ||
| Utilities | 40¢ | per labor hour | ||
| Maintenance | 30¢ | per labor hour | ||
| Salaries | $41,000 | per month | ||
| Depreciation | $16,200 | per month | ||
| Property taxes | $3,000 | per month | ||
| Insurance | $1,100 | per month | ||
| Maintenance | $1,100 | per month | ||
| Selling and Administrative | |||
| Variable selling and administrative cost per unit is $1.50. | |||
| Advertising | $15,000 | a month | |
| Insurance | $1,400 | a month | |
| Salaries | $71,000 | a month | |
| Depreciation | $2,300 | a month | |
| Other fixed costs | $3,000 | a month | |
Other Information
The Cash balance on December 31, 2019, totaled $101,000, but
management has decided it would like to maintain a cash balance of
at least $800,000 beginning on January 31, 2020. Dividends are paid
each month at the rate of $2.40 per share for 5,340 shares
outstanding. The company has an open line of credit with Romney’s
Bank. The terms of the agreement requires borrowing to be in $1,000
increments at 9% interest. Waterways borrows on the first day of
the month and repays on the last day of the month. A $460,000
equipment purchase is planned for February.
For the first quarter of 2020, prepare a cash budget.
(Round answers to 0 decimal places, e.g.
2,520.
In: Accounting
Entity A is a listed company that operates the cruise ship business. One of the cruise ships was purchased on 1 Oct 2011. This cruise ship is made up of three main components: (1) cruise’s fabric, (2) cabins and entertainment area and (3) fittings propulsion system.
Details of the cost of its components and their estimated useful lives are as below:
Components Original cost Depreciation basis
(1) Cruise’s fabric (hull, decks, etc.) HK$37,500,000 50 years straight-line
(2) Cabins and entertainment area fittings HK$18,750,000 15 years straight-line
(3) Propulsion system HK$12,500,000 useful life of 80,000 hours
On 30 Sep 2019, no further capital expenditure had been incurred on the cruise ship.
In the year ended 30 Sep 2019, the cruise had experienced a high level of engine trouble, which had cost Entity A considerable revenue loss and compensation costs. The measured expired life of the propulsion system on 30 Sep 2019 was 50,000 hours. Due to the unreliability of the engines, a decision was made by Entity A on 1 Oct 2019 to replace the whole of the propulsion system at a cost of HK$17,500,000. The old propulsion system was also sold to a second-hand machinery shop with a loss on disposal of $4,250,000. The cash from the disposal was received on 20 Oct 2019. The expected life of the new propulsion system was 160,000 hours and in the year ended 30 Sep 2020, the cruise had used its engines for 10,000 hours.
At the same time as the propulsion system replacement, Entity A took this opportunity to upgrade the cabin and entertainment facilities at a cost of HK$7,500,000 and repaint the cruise’s fabric at a cost of HK$2,500,000 respectively. After the upgrade of the cabin and entertainment area fittings, it was estimated that their remaining useful life was 10 years.
For calculating depreciation, all the works on the cruise can be assumed to have been completed on 1 Oct 2019. All residual values can be taken as NIL.
REQUIRED:
(1) Measure the depreciation expense of the Cruise’s Fabric for the year ended 30 Sep 2020.
Answer = $
(2) Measure the depreciation expense of the Cabins and entertainment area fittings for the year ended 30 Sep 2020.
Answer = $
(3) Measure the depreciation expense of the Propulsion system for the year ended 30 Sep 2020.
Answer = $
(4) Measure the carrying amount of the Cruise’s Fabric on 30 Sep 2020.
Answer = $
(5) Measure the carrying amount of the Cabins and entertainment area fittings on 30 Sep 2020.
Answer = $
(6) Measure the carrying amount of the Propulsion system on 30 Sep 2020.
Answer = $
(7) Measure the carrying amount of Entity A’s cruise ship on 30 Sep 2020.
Answer = $
(8) Measure the cash received from the sale of the old propulsion system.
Answer = $
In: Accounting
SUBJECT is FINANCE
Free Cash Flows
Rhodes Corporation’s financial statements are shown below.
Rhodes Corporation: Income Statements for Year Ending
December 31
(Millions of Dollars)
| 2020 | 2019 | ||||
| Sales | $ | 13,000 | $ | 11,000 | |
| Operating costs excluding depreciation | 11,588 | 9,682 | |||
| Depreciation and amortization | 400 | 370 | |||
| Earnings before interest and taxes | $ | 1,012 | $ | 948 | |
| Less interest | 240 | 200 | |||
| Pre-tax income | $ | 772 | $ | 748 | |
| Taxes (25%) | 193 | 187 | |||
| Net income available to common stockholders | $ | 579 | $ | 561 | |
| Common dividends | $ | 202 | $ | 200 | |
Rhodes Corporation: Balance Sheets as of December 31 (Millions of Dollars)
| 2020 | 2019 | ||||
| Assets | |||||
| Cash | $ | 650 | $ | 600 | |
| Short-term investments | 120 | 100 | |||
| Accounts receivable | 2,750 | 2,500 | |||
| Inventories | 1,650 | 1,400 | |||
| Total current assets | $ | 5,170 | $ | 4,600 | |
| Net plant and equipment | 3,750 | 3,500 | |||
| Total assets | $ | 8,920 | $ | 8,100 | |
| Liabilities and Equity | |||||
| Accounts payable | $ | 1,300 | $ | 1,200 | |
| Accruals | 650 | 600 | |||
| Notes payable | 192 | 100 | |||
| Total current liabilities | $ | 2,142 | $ | 1,900 | |
| Long-term debt | 1,300 | 1,200 | |||
| Total liabilities | $ | 3,442 | 3,100 | ||
| Common stock | 3,901 | 3,800 | |||
| Retained earnings | 1,577 | 1,200 | |||
| Total common equity | $ | 5,478 | $ | 5,000 | |
| Total liabilities and equity | $ | 8,920 | $ | 8,100 | |
Suppose the federal-plus-state tax corporate tax is 25%. Answer the following questions.
2020: $ million
2019: $ million
2020: $ million
2019: $ million
$ million
%
| After-tax interest payment | $ million |
| Reduction (increase) in debt | $ million |
| Payment of dividends | $ million |
| Repurchase (Issue) stock | $ million |
| Purchase (Sale) of short-term investments | $ million |
In: Finance
Windsor Corporation was formed 5 years ago through a public
subscription of common stock. Daniel Brown, who owns 15% of the
common stock, was one of the organizers of Windsor and is its
current president. The company has been successful, but it
currently is experiencing a shortage of funds. On June 10, 2021,
Daniel Brown approached the Topeka National Bank, asking for a
24-month extension on two $34,970 notes, which are due on June 30,
2021, and September 30, 2021. Another note of $5,970 is due on
March 31, 2022, but he expects no difficulty in paying this note on
its due date. Brown explained that Windsor’s cash flow problems are
due primarily to the company’s desire to finance a $300,080 plant
expansion over the next 2 fiscal years through internally generated
funds.
The commercial loan officer of Topeka National Bank requested the
following financial reports for the last 2 fiscal years.
|
Windsor Corporation |
||||
|---|---|---|---|---|
| Assets |
2021 |
2020 |
||
|
Cash |
$18,120 | $12,410 | ||
|
Notes receivable |
147,220 | 132,930 | ||
|
Accounts receivable (net) |
130,790 | 124,530 | ||
|
Inventories (at cost) |
104,940 | 49,570 | ||
|
Plant & equipment (net of depreciation) |
1,446,500 | 1,416,510 | ||
|
Total assets |
$1,847,570 | $1,735,950 | ||
| Liabilities and Owners’ Equity | ||||
|
Accounts payable |
$79,360 | $90,220 | ||
|
Notes payable |
75,910 | 61,040 | ||
|
Accrued liabilities |
8,250 | 2,550 | ||
|
Common stock (130,000 shares, $10 par) |
1,296,650 | 1,312,800 | ||
|
Retained earningsa |
387,400 | 269,340 | ||
|
Total liabilities and stockholders’ equity |
$1,847,570 | $1,735,950 | ||
| aCash dividends were paid at the rate of $1 per share in fiscal year 2020 and $2 per share in fiscal year 2021. | ||||
|
Windsor Corporation |
||||
|---|---|---|---|---|
|
2021 |
2020 |
|||
|
Sales revenue |
$2,994,540 | $2,716,340 | ||
|
Cost of goods solda |
1,536,450 | 1,415,660 | ||
|
Gross margin |
1,458,090 | 1,300,680 | ||
|
Operating expenses |
856,120 | 784,640 | ||
|
Income before income taxes |
601,970 | 516,040 | ||
|
Income taxes (40%) |
240,788 | 206,416 | ||
|
Net income |
$361,182 | $309,624 | ||
| aDepreciation charges on the plant and equipment of $99,960 and $101,650 for fiscal years ended March 31, 2020 and 2021, respectively, are included in cost of goods sold. | ||||
(a)
Compute the following items for Windsor Corporation.
(Round answers to 2 decimal places, e.g. 2.25 or
2.25%.)
| 1. | Current ratio for fiscal years 2020 and 2021. | |
|---|---|---|
| 2. | Acid-test (quick) ratio for fiscal years 2020 and 2021. | |
| 3. | Inventory turnover for fiscal year 2021. | |
| 4. | Return on assets for fiscal years 2020 and 2021. (Assume total assets were $1,705,230 at 3/31/19.) | |
| 5. | Percentage change in sales, cost of goods sold, gross margin, and net income after taxes from fiscal year 2020 to 2021. |
In: Accounting
You found your dream house. It will cost you $300000 and you will put down $50000 as a down payment. For the rest you get a 30-year 5.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)?
In: Finance
You found your dream house. It will cost you $300000 and you will put down $30000 as a down payment. For the rest you get a 30-year 5.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)
In: Finance
You found your dream house. It will cost you $200000 and you will put down $40000 as a down payment. For the rest you get a 30-year 5.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)?
In: Finance
Explain why a firm only shuts down once the price drops to the minimum of the average variable cost (AVC) curve, rather than shutting down as soon as the price falls below the minimum of the average total cost (ATC) curve.
In: Economics
In: Biology
You found your dream house. It will cost you $300000 and you will put down $45000 as a down payment. For the rest you get a 30-year 4.5% mortgage. What will be your monthly mortgage payment in $ (assume no early repayment)?
In: Finance