You have just started up a new company in NS that produces software for the waste management industry. You need to invest $100,000 immediately to purchase computer equipment (CCA class number 45 with a CCA rate of 45% and no salvage value). The investment is comprised of $50,000 cash and $50,000 from a bank loan charging an effective annual interest rate of 4% with annual payments. If the anticipated operating costs (excluding your salary) are $15,000 per year increasing at 5% per year and the anticipated revenue is $70,000 per year increasing at 3% per year, what constant amount can you withdraw each year as salary ( ver the four-year life of the project if you want to make 5% per year (return on your investment)?

You have just started up a new company in NS that produces software for the waste management industry. You need to invest $100,000 immediately to purchase computer equipment (CCA class number 45 with a CCA rate of 45% and no salvage value). The investment is comprised of $50,000 cash and $50,000 from a bank loan charging an effective annual interest rate of 4% with annual payments. If the anticipated operating costs (excluding your salary) are $15,000 per year increasing at 5% per year and the anticipated revenue is $70,000 per year increasing at 3% per year, what constant amount can you withdraw each year as salary ( ver the four-year life of the project if you want to make 5% per year (return on your investment)?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 5R

See similar textbooks

Similar questions

Each of the following scenarios is independent. All cash flows are after-tax cash flows. Required: 1. Patz Corporation is considering the purchase of a computer-aided manufacturing system. The cash benefits will be 800,000 per year. The system costs 4,000,000 and will last eight years. Compute the NPV assuming a discount rate of 10 percent. Should the company buy the new system? 2. Sterling Wetzel has just invested 270,000 in a restaurant specializing in German food. He expects to receive 43,470 per year for the next eight years. His cost of capital is 5.5 percent. Compute the internal rate of return. Did Sterling make a good decision?
You work for a logistics company, which considers to invest in a computerized system to improve efficiency. The initial cost of implementation for the system is $90,000. Furthermore, it will cost $25,000 per year to maintain the system. Due to the fast nature of the business, your company can use the system for five years and there will be no salvage value at the end of the service period. Thanks to the new system, you estimate that the company will save $65,000 in operating costs each year. In addition, the increase in the effciency would bring $35,000 per year in additional revenues during the service life of the system. Given that your company's MARR is 15%, find the present worth of this investment. A) -$73,239 B) $161,412 C) $251,412 D) Answers A, B and C are not correct
You are working as a finance manager for a construction company. The company is considering to buy a new machine which is expected to boost its revenue. A supplier offered two alternative machinery options for the company’s choice. Each machine will last 5 years and have no salvage value at the end. The company’s required rate of return for all investment projects is 10.5%. The cash flows of the projects are provided below. Machinery option 1 Machinery option 2 Cost $235,000 $272,000 Future Cash Flows Year 1 Year 2 Year 3 Year 4 Year 5 85 000 91 000 98 000 94 000 86 000 93 000 95 000 98 000 97 000 83 000 Required: Identify which option of equipment should the company accept based on Profitability Index (PI) method? Identify which machinery option should the company accept based on simple pay back method if the payback criterion is maximum 2.5 years? If the company’s management would like to know how much each machinery option can improve the…
Assuming that you would like to buy an equipment for your small business. Using the information below, calculate the Rate of Return and the Pay Back Period for the investment. After presenting your calculations, explain why you think this will (or will not) be a good investment. Here are the numbers: Cost of the investment is $100,000 Estimated depreciable life of investment is 5 years Annual depreciated charge is $15,000 Estimated average profit over depreciable life is $10,000.
Your firm is contemplating the purchase of a new $500,000 computer-based order entry system. The system will be depreciated using the MACRS 5-year depreciation schedule. It will be worth $80,000 at the end of the project in 6 years. You will save $50,000 before taxes per year in order processing costs, and you will be able to reduce net working capital by $70,000. You will also increase sales by $100,000 per year for the first year and this number will increase by 3% per year. If the tax rate is 30 percent, and the required rate of return is 10%, what is the NPV of this project? Must be done in excel and use cell referencing.
Suppose you are a financial manager at a car rental company. The company recently purchased a batch of luxury cars that will be on the market for rent soon. The purchasing price of each car is $100,000 and the annual maintenance costs expect to be $15, 000 in year 1 through 5. These cars will be depreciated over 5 years using straight-line depreciatin and there will be no salvage value after that. Assume the required rate of return is 8% and the corporate tax rate is 21%. Now here comes a potential customer who is interested in renting the car for 5 years. Suppose the 5 lease payment will each occur at the beginning of the year. What is the pre-tax rental price you need to charge the customer in order for a break-even within these 5 years?
b) Magen's Bakery, Inc., is considering the purchase of a new cake mixing equipment for $200,000. This would result in an increase in earnings before interest and taxes of $50,000 per year. To operate the machine efficiently, worker's training session would cost $10,000 after taxes. It would cost another $10,000, after taxes, to get equipment to be ready for use. Acquiring this project would cause changes in the working capital. The accountant has provided the following figures for the calculation of the working capital: Accounts receivables Inventory Accounts payables Without the project $25 000 $35 000 $50 000 With the project $55 000 $70 000 $65 000 This machine has an expected life of 10 years, after which it would have no salvage value. Finally, to purchase the new machine, it appears that the firm would have to borrow $80,000 at 10 percent interest from its local bank, resulting in additional interest payments of $8,000 per year. Assume the use of the simplified straight-line…
A company is considering buying a piece of machinery that costs $20,000 and has a salvage value of $6,000 at the end of its 5-year useful life. The machinery nets $5,000 per year in annual revenues. The internal rate of return (IRR) on this investment is between__________. if the company considering purchasing the machine uses a MARR of 12%, would you recommend that it be bought?
b) Magen's Bakery, Inc., is considering the purchase of a new cake mixing equipment for $200,000. This would result in an increase in earnings before interest and taxes of $50,000 per year. To operate the machine efficiently, worker's training session would cost $10,000 after taxes. It would cost another $10,000, after taxes, to get equipment to be ready for use. Acquiring this project would cause changes in the working capital. The accountant has provided the following figures for the calculation of the working capital: Without the project $25 000 $35 000 $50 000 With the project $55 000 $70 000 $65 000 Accounts receivables Inventory Accounts payables This machine has an expected life of 10 years, after which it would have no salvage value. Finally, to purchase the new machine, it appears that the firm would have to borrow $80,000 at 10 percent interest from its local bank, resulting in additional interest payments of $8,000 per year. Assume the use of the simplified straight-line…
You are considering starting a new doughnut shop in the Prince Kuhio Mall. You wish to complete a cash flow statement to be used for capital budgeting purposes. You will have to purchase $80,000 of equipment with cash you have saved to manufacture the doughnuts. You will purchase the equipment on the day you start the business. You will depreciate the equipment using 3-year straight-line depreciation to a salvage value of $20,000. You will need to have $20,000 of inventory and you will need to have $5,000 in cash for the cash registers. You will need to have the inventory and cash in place the day you start the business and it will remain in place throughout the life of the business. You will owe your suppliers $5,000 at all times, beginning the day that you start the business and continuing through the life of the business. Based on your sales estimate, you believe that you will be able to sell $1,000,000 of doughnuts per year. You have estimated labor costs to be $200,000 for the…
Some equipment is needed for a construction project. It can be leased for $150,000 annually, or it can be purchased for $900,000 at the beginning and sold for $225,000 at the end of 3 years. What is the rate of return for owning the equipment rather than leasing it?
An auto repair company needs a new machine that will check for defective sensors. The machine has an initial investment of $224,000. Incremental revenues, including cost savings, are $120,000, and incremental expenses, including depreciation, are $50,000. There is no salvage value. What is the accounting rate of return (ARR)?