If you buy a factory for $250,000 and the terms are 20 percent down, the balance to paid off over 30 years at a 12 percent rate of interest on the unpaid balance, what are the 30 equal annual payments.?My question is what would be the pv (resent value), and number of periods. I am doing this in excel

If you buy a factory for $250,000 and the terms are 20 percent down, the balance to paid off over 30 years at a 12 percent rate of interest on the unpaid balance, what are the 30 equal annual payments.?My question is what would be the pv (resent value), and number of periods. I am doing this in excel

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter5: The Time Value Of Money

Section: Chapter Questions

Problem 16P

See similar textbooks

Similar questions

Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.
Mason, Inc., is considering the purchase of a patent that has a cost of $85000 and an estimated revenue producing lite of 4 years. Mason has a required rate of return that is 12% and a cost of capital of 11%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 8%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
How much must be invested now to receive $30,000 for 10 years if the first $30.000 is received one year from now and the rate is 8%?
Now assume that it is several years later. The brothers are concerned about the firm’s current credit terms of net 30, which means that contractors buying building products from the firm are not offered a discount and are supposed to pay the full amount in 30 days. Gross sales are now running $1,000,000 a year, and 80% (by dollar volume) of the firm’s paying customers generally pay the full amount on Day 30; the other 20% pay, on average, on Day 40. Of the firm’s gross sales, 2% ends up as bad-debt losses. The brothers are now considering a change in the firm’s credit policy. The change would entail: (1) changing the credit terms to 2/10, net 20, (2) employing stricter credit standards before granting credit, and (3) enforcing collections with greater vigor than in the past. Thus, cash customers and those paying within 10 days would receive a 2% discount, but all others would have to pay the full amount after only 20 days. The brothers believe the discount would both attract additional customers and encourage some existing customers to purchase more from the firm—after all, the discount amounts to a price reduction. Of course, these customers would take the discount and hence would pay in only 10 days. The net expected result is for sales to increase to $1,100,000; for 60% of the paying customers to take the discount and pay on the 10th day; for 30% to pay the full amount on Day 20; for 10% to pay late on Day 30; and for bad-debt losses to fall from 2% to 1% of gross sales. The firm’s operating cost ratio will remain unchanged at 75%, and its cost of carrying receivables will remain unchanged at 12%. To begin the analysis, describe the four variables that make up a firm’s credit policy and explain how each of them affects sales and collections.
A grocery store is considering the purchase of a new refrigeration unit with an Initial Investment of $412,000, and the store expects a return of $100,000 in year one, $72000 in years two and three, $65,000 in years four and five, and $38,000 in year six and beyond, what is the payback period?
Conestoga Plumbing plans to invest in a new pump that is anticipated to provide annual savings for 10 years of $50,000. The pump can be sold at the end of the period for $100,000. What is the present value of the investment in the pump at a 9% interest rate given that savings are realized at year end?
A restaurant is considering the purchase of new tables and chairs for their dining room with an initial investment cost of $515,000, and the restaurant expects an annual net cash flow of $103,000 per year. What is the payback period?
Jullo Company is considering the purchase of a new bubble packaging machine. If the machine will provide $20,000 annual savings for 10 years and can be sold for $50,000 at the end of the period, what is the present value of the machine investment at a 9% interest rate with savings realized at year end?
Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows: The system will cost 9,000,000 and last 10 years. The companys cost of capital is 12 percent. Required: 1. Calculate the payback period for the system. Assume that the company has a policy of only accepting projects with a payback of five years or less. Would the system be acquired? 2. Calculate the NPV and IRR for the project. Should the system be purchasedeven if it does not meet the payback criterion? 3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of 1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of 300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Does the decision change? Suppose that the salvage value is only half what is projected. Does this make a difference in the outcome? Does salvage value have any real bearing on the companys decision?
Bouvier Restaurant is considering an investment in a grill that costs $140,000, and will produce annual net cash flows of $21,950 for 8 years. The required rate of return is 6%. Compute the net present value of this investment to determine whether Bouvier should invest in the grill.
Towson Industries is considering an investment of $256,950 that is expected to generate returns of $90,000 per year for each of the next four years. What Is the Investments internal rate of return?