Answered: Calculate net present value (NPV) and…

Business

Finance

Calculate net present value (NPV) and internal rate of return (IRR) of both the investments.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterMB: Model-building Problems

Section: Chapter Questions

Problem 15M

See similar textbooks

Similar questions

Ali is an intelligent business woman. She makes her investments after a very thoughtful process. In January 2018 , her manager has shown her some projects with the following details Option A Investment into a towel business that initially cost $200,000 and then will generate cash inflow of $24000 per year for the next 10 years Option B Investment into a detergent business that initially cost $190,000 and then will generate cash inflow of $20,000 for each of next 12 years. The rate of return associated with both the investments is 12%. Calculate Payback period, discounted payback period, profitability index, net present value (NPV) and internal rate of return (IRR) of both the investments. Rank the projects based on each evaluation criteria. Comment on which investment Mrs. Ali should pick on the basis NPV and IRR.
Ali is an intelligent business woman. She makes her investments after a very thoughtful process. In January 2018, her manager has shown her some projects with the following details Option A Investment into a towel business that initially cost $100,000 and then will generate cash inflow of $14000 per year for the next 10 years Option B Investment into a detergent business that initially cost $90,000 and then will generate cash inflow of $10,000 for each of next 12 years. The rate of return associated with both the investments is 11%. Calculate net present value (NPV) and internal rate of return (IRR) of both the investments. Comment on which investment Mrs Alis should pick on the basis NPV and IRR.
Mr.Andi is a manager at an automation company. As part of his future planning, Mr.Andi plan to manage an investment IDR 100 thousand in the first year and increase this amount is 10% annually. To solve this problem, you have to create a spreadsheet from the data provided to complete your calculations along with the cash flow. Based on the data given: (a) How long will Mr.Andi's account have value in the future of IDR 3,000,000 at a rate of return of 6% per annum? (b) If Mr.Andi counts up to the next 30 years, find the nominal amount in the next 10, 20, and 30 years that Mr. Andi will achieve. The calculation spreadsheet can describe the amount deposited annually.
Mary is considering opening a hobby and craft store. Mary plans to operate the business for six years. Mary requires a minimum 6% return on this investment. (Ignore income taxes in this problem). The data pertaining to her investment opportunity are: (see attached image). Mary plans to operate the business for six years. Mary requires a minimum 6% return on this investment. What is the total cash outflow needed at the beginning of the project.
Mary is considering opening a hobby and craft store. Mary plans to operate the business for six years. Mary requires a minimum 6% return on this investment. (Ignore income taxes in this problem). The data pertaining to her investment opportunity are: (see attached image). Mary plans to operate the business for six years. Mary requires a minimum 6% return on this investment. What is the total cash inflow that comes JUST in year 6? Do not include the annual cash flows from the earlier problem.
Mary is considering opening a hobby and craft store. Mary plans to operate the business for six years. Mary requires a minimum 6% return on this investment. (Ignore income taxes in this problem). The data pertaining to her investment opportunity are: (see attached image). Mary plans to operate the business for six years. Mary requires a minimum 6% return on this investment. What is the present value factor you will use for cash inflows that come JUST in year 6? Enter your answer to three decimals.
Nicole Mackisey is thinking of forming her own spa business, Nicole's Getaway Spa (NGS). Nicole expects that she and two family members will each contribute $10,000 to the business and receive 1,000 shares each. Nicole forecasts the following amounts for the first year of operations, ending December 31, 2021: Cash on hand and in the bank, $2,250; amounts due from customers from spa treatments, $1,790; building and equipment, $71,000; amounts owed to beauty supply outlets for spa equipment, $4,670; notes payable to a local bank for $38,970. Cash dividends of $3,000 will be paid to the stockholders during the year. Nicole also forecasts that first-year sales revenues will be $43,600; wages will be $24,500; the cost of supplies used up will be $7,500; office expenses will be $5,500; and income taxes will be $1,700. Required: Based on Nicole's estimates, prepare a (forecasted) CREATE A INCOME STATEMENT, RETAINED EARNINGS AND BALANCE SHEET for Nicole's Getaway Spa for the year ended…
Nicole Mackisey is thinking of forming her own spa business, Nicole's Getaway Spa (NGS). Nicole expects that she and two family members will each contribute $10,000 to the business and receive 1,000 shares each. Nicole forecasts the following amounts for the first year of operations, ending December 31, 2021: Cash on hand and in the bank, $2,850; amounts due from customers from spa treatments, $1,850; building and equipment, $77,000; amounts owed to beauty supply outlets for spa equipment, $4,730; notes payable to a local bank for $39,570. Cash dividends of $2,000 will be paid to the stockholders during the year. Nicole also forecasts that first-year sales revenues will be $58,200; wages will be $27,500; the cost of supplies used up will be $10,500; office expenses will be $8,500; and income taxes will be $2,300. CC1-1 (Algo) Part 1 Required: 1. Based on Nicole's estimates, prepare a (forecasted) income statement for Nicole's Getaway Spa for the year ended December 31, 2021. NICOLE'S…
James Smith is a financial adviser at a reputable financial institution in Jamaica. He was the keynote speaker on financial management at a recent conference and was asked questions on the time value of money. James is asking you to provide the answers to the following questions asked by the attendees at the conference. Sandra is currently saving $1,250 each month at 12% per annum. How much money will be in her account at the end of 5 years? 2. How much money should Anny invest today, so that she will have $10,500 in her bank account in four years’ time, assuming that the interest rate is 5% compounded annually? 3. A typical credit card agreement quotes an interest rate of 15% per annum. Monthly payments are required. Calculate the actual interest rate that will be paid on such a credit card (i.e. EAR)?
Mariam Alikozay is considering opening a cold storage refrigeration business. She would invest $50,000 to purchase equipment and furnishings and another $100,000 for inventories and other working capital needs. Rent on the building used by the business will be $25,000 per year. In addition to building rent, other annual cash outflows for operating costs will amount to $44,000. She estimates that the annual cash inflow from the business will amount to $100,000. Mariam plans to operate the business for only six years. She estimates that the equipment and furnishings could be sold at that time for about 10% of its original cost. The discount rate is 16%. Compute the net present value of this investment. Please post in word , not picture
Mariam Alikozay is considering opening a cold storage refrigeration business. She would invest $50,000 to purchase equipment and furnishings and another $100,000 for inventories and other working capital needs. Rent on the building used by the business will be $25,000 per year. In addition to building rent, other annual cash outflows for operating costs will amount to $44,000. She estimates that the annual cash inflow from the business will amount to $100,000. Mariam plans to operate the business for only six years. She estimates that the equipment and furnishings could be sold at that time for about 10% of its original cost. The discount rate is 16%. Compute the net present value of this investment.
Aaron Heath is seeking part-time employment while he attends school. He is considering purchasing technical equipment that will enable him to start a small training services company that will offer tutorial services over the Internet. Aaron expects demand for the service to grow rapidly in the first two years of operation as customers learn about the availability of the Internet assistance. Thereafter, he expects demand to stabilize. The following table presents the expected cash flows: In addition to these cash flows, Aaron expects to pay $20,100 for the equipment. He also expects to pay $3,500 for a major overhaul and updating of the equipment at the end of the second year of operation. The equipment is expected to have a $1,800 salvage value and a four year useful life. Aaron desires to earn a rate of return of 8 percent. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)