Bill has been adding funds to his investment account each year for the past 3 years. He started with an initial investment of $1,000. After earning a 10% return the first year, he added $3,000 to his portfolio. In this year his investments lost 5%. Undeterred, Bill added $2,000 the next year and earned a 2% return. Last year, discouraged by the recent results, he only added $500 to his portfolio, but in this final year his investments earned 8%. What was Bill's dollar-weighted average return for his investments?
In: Finance
A project requires an initial investment of $20,000,000. The life of the project is 3 years. The $20,000,000 investment will be depreciated using the three-year modified accelerated cost recovery system (MACRS) class (see the table below). The firm estimates that, in the first year, the revenues and total production costs will be $60,000,000 and $45,000,000, respectively, in nominal terms. After that the sales and production costs are expected to increase at the inflation rate of 4 percent per year over the life of the project. In addition, it has a before-tax salvage value (or resale value) at the end of the project of $9,000,000. The mine will require a net working capital (NWC) investment of 7 percent of sales. The NWC will be built up in the year prior to the sales (e.g., the net working capital requirement for year 0 is 7% of sales in year 1 and the additional net working capital cash flow for year 1 is 7% of the difference in sales between year 2 and year 1). All net working capital cash flows are fully recoverable when the project ends. The tax rate is 25 percent. The project only depreciates the $20,000,000 initial cost. The salvage value is excluded from depreciation. a) Find the operating cash flow (OCF) of this project for each year. b) If the real discount rate (or required rate of return) of the project is 14 percent, what is its net present value (NPV)? Year MACRS Depreciation Allowances for 3-year Recovery Period Class 1 33.33% 2 44.44% 3 14.82% 4 7.41%
In: Finance
Your friend and colleague has been working for about a year since graduating from university. He has come to you for advice on his saving and spending habits. You have accumulated the following information on his savings and spending that has occurred over the past year:
|
Saving/Spending |
Amount $ |
|
Salary received over the last year, net of income tax |
45,000 |
|
Rent and utilities paid |
16,600 |
|
Car expenses paid |
4,800 |
|
Credit card debt at the start of the year |
1,000 |
|
Food, entertaining, recreation paid |
6,000 |
|
Credit card debt at the end of the year |
2,500 |
|
Line of credit at the start of the year |
2,500 |
|
Line of credit at the end of the year |
1,200 |
|
Purchase of car |
20,000 |
|
Car loan at the end of the year |
15,000 |
|
Cash account balance at the beginning of the year |
500 |
|
Cash received from disposal of motorcycle |
1,000 |
|
Cash received from disposal of computer |
100 |
|
Cash account balance at the end of the year |
1,000 |
|
Purchase of Investments |
5,500 |
|
Student loan at the beginning of the year |
15,000 |
|
Student loan at the end of the year |
10,000 |
|
Purchase of new computer |
1,500 |
|
Interest expense paid |
1,400 |
Instructions
Prepare a statement of cash flow for your friend from information provided above using the direct method.
Can you provide some advice to your friend on how he could improve his cash flow strategies, such as managing debt levels and terms of payment?
Please ensure that your response is written in full sentences and that you provide an explanation and/or a calculation to support your answers.
In: Accounting
X Company is considering the replacement of an existing machine. The new machine costs $1.8 million and requires installation costs of $250,000. The existing machine can be sold currently for $125,000 before taxes. The existing machine is 3 years old, cost $1 million when purchased, and has a $290,000 book value and a remaining useful life of 5 years. It was being depreciated under MACRS using a 5-year recovery period. If it is held for 5 more years, the machine’s market value at the end of year 5 will be zero. Over its 5-year life, the new machine should reduce operating costs by $650,000 per year, and will be depreciated under MACRS using a 5-year recovery period. The new machine can be sold for $150,000 net of removal and cleanup costs at the end of 5 years. A $30,000 increase in net working capital will be required to support operations if the new machine is acquired. The firm has adequate operations against which to deduct any losses experienced on the sale of the existing machine. The firm has a 15% cost of capital, is subject to a 40% tax rate and requires a 42-month payback period for major capital projects.
5-Year MACRS
Year 1 20%
Year 2 32%
Year 3 19%
Year 4 12%
Year 5 12%
Year 6 5%
1. Should they accept or reject the proposal to replace the machine?
2. What is the NPV?
3. What is the IRR?
4. What is the payback period?
In: Finance
X Company is considering the replacement of an existing machine. The new machine costs $1.8 million and requires installation costs of $250,000. The existing machine can be sold currently for $125,000 before taxes. The existing machine is 3 years old, cost $1 million when purchased, and has a $290,000 book value and a remaining useful life of 5 years. It was being depreciated under MACRS using a 5-year recovery period. If it is held for 5 more years, the machine’s market value at the end of year 5 will be zero. Over its 5-year life, the new machine should reduce operating costs by $650,000 per year, and will be depreciated under MACRS using a 5-year recovery period. The new machine can be sold for $150,000 net of removal and cleanup costs at the end of 5 years. A $30,000 increase in net working capital will be required to support operations if the new machine is acquired. The firm has adequate operations against which to deduct any losses experienced on the sale of the existing machine. The firm has a 15% cost of capital, is subject to a 40% tax rate and requires a 42-month payback period for major capital projects.
5-Year MACRS
Year 1 20%
Year 2 32%
Year 3 19%
Year 4 12%
Year 5 12%
Year 6 5%
1. Should they accept or reject the proposal to replace the machine?
2. What is the NPV?
3. What is the IRR?
4. What is the payback period?
In: Finance
United Firm is planning to buy a new machine for $200,000. The firm’s tax rate is 40%, and its overall WACC is 10%. The new machine has an economic life of 4 years and the salvage value will be $25,000 after 4 years. United Firm is using MACRS 3-year class to depreciate its assets. (i.e. Year 1, depreciate rate is 33.33%, year 2 depreciate rate is 44.45%, year 3 depreciate rate is 14.81% and year 4 depreciation rate is 7.41%). It costs $40,000 for the shipping and installation. Each year, United Firm expects to get an incremental sale of 1,250 units from the new machine. Cost (excluding depreciation) will be $100 for each unit in the first year. It will then increase by 3% per year. Unit price starts at $200 per unit in the first year and will increase by 3% per year as well. In addition, net working capital would have to increase by an amount equal to 12% of sales revenues.
In: Finance
X Company is considering the replacement of an existing machine. The new machine costs $1.8 million and requires installation costs of $250,000. The existing machine can be sold currently for $125,000 before taxes. The existing machine is 3 years old, cost $1 million when purchased, and has a $290,000 book value and a remaining useful life of 5 years. It was being depreciated under MACRS using a 5-year recovery period. If it is held for 5 more years, the machine’s market value at the end of year 5 will be zero. Over its 5-year life, the new machine should reduce operating costs by $650,000 per year, and will be depreciated under MACRS using a 5-year recovery period. The new machine can be sold for $150,000 net of removal and cleanup costs at the end of 5 years. A $30,000 increase in net working capital will be required to support operations if the new machine is acquired. The firm has adequate operations against which to deduct any losses experienced on the sale of the existing machine. The firm has a 15% cost of capital, is subject to a 40% tax rate and requires a 42-month payback period for major capital projects.
5-Year MACRS
Year 120%
Year 232%
Year 319%
Year 412%
Year 512%
Year 65%
1. Should they accept or reject the proposal to replace the machine?
2. What is the NPV?
3. What is the IRR?
4. What is the payback period?
In: Finance
On January 1, Boston Company completed the following transactions (use a 7% annual interest rate for all transactions): (FV of $1, PV of $1, FVA of $1, and PVA of $1) (Use the appropriate factor(s) from the tables provided.) Borrowed $117,200 for nine years. Will pay $7,100 interest at the end of each year and repay the $117,200 at the end of the 9th year. Established a plant remodeling fund of $491,650 to be available at the end of Year 10. A single sum that will grow to $491,650 will be deposited on January 1 of this year. Agreed to pay a severance package to a discharged employee. The company will pay $76,100 at the end of the first year, $113,600 at the end of the second year, and $151,100 at the end of the third year. Purchased a $175,500 machine on January 1 of this year for $35,100 cash. A five-year note is signed for the balance. The note will be paid in five equal year-end payments starting on December 31 of this year.
Required:
1. In transaction (a), determine the present value of the debt. (Round your answer to nearest whole dollar.)
2-a. In transaction (b), what single sum amount must the company deposit on January 1 of this year? (Round your answer to nearest whole dollar.)
2-b. What is the total amount of interest revenue that will be earned? (Round your answer to nearest whole dollar.)
3. In transaction (c), determine the present value of this obligation.
4-a. In transaction (d), what is the amount of each of the equal annual payments that will be paid on the note?
4-b. What is the total amount of interest expense that will be incurred?
In: Accounting
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,000 | 12,000 | 14,000 | 13,000 |
The selling price of the company’s product is $18.00 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 $70,200.
The company expects to start the first quarter with 1,650 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,850 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.
|
|
.
|
In: Accounting
Entries for Bonds Payable, including bond redemption The following transactions were completed by Winklevoss Inc., whose fiscal year is the calendar year: Year 1 July 1. Issued $7,000,000 of five-year, 11% callable bonds dated July 1, Year 1, at a market (effective) rate of 13%, receiving cash of $6,496,782. Interest is payable semiannually on December 31 and June 30. Dec. 31. Paid the semiannual interest on the bonds. The bond discount amortization of $50,322 is combined with the semiannual interest payment. Dec. 31. Closed the interest expense account. Year 2 June 30. Paid the semiannual interest on the bonds. The bond discount amortization of $50,322 is combined with the semiannual interest payment. Dec. 31. Paid the semiannual interest on the bonds. The bond discount amortization of $50,322 is combined with the semiannual interest payment. Dec. 31. Closed the interest expense account. Year 3 June 30. Recorded the redemption of the bonds, which were called at 98. The balance in the bond discount account is $301,930 after payment of interest and amortization of discount have been recorded. (Record the redemption only.) Required: 1. Journalize the entries to record the foregoing transactions. If an amount box does not require an entry, leave it blank or enter "0". When required, round your answers to the nearest dollar. 2. Indicate the amount of the interest expense in (a) Year 1 and (b) Year 2. a. Year 1 $ 1,010,644 b. Year 2 $ 1,010,644 3. Determine the carrying amount of the bonds as of December 31, Year 2.
In: Accounting