Lancers, Ltd. is contemplating a $350,000 investment of equipment that they feel can add $90,000 in...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Lancers, Ltd. is contemplating a $350,000 investment of equipment that they feel can add $90,000 in revenues in Year #1 and Year #2, and $100,000 in revenue in Year 3, and $105,000 in Years 4 & 5. They estimate variable expenses at 7.5% of Sales and additional fixed costs would be approximately $9,500 per year. The equipment should last 5 years and have a salvage value of $15,000 at the end of its life. They've decided to use straight line depreciation over the equipment life. Instructions: 1) Complete the above worksheet using the information provided in the Scenario at the top right. 2) A Yellow box means you need to insert numbers either hard coded or via a simple formula. 3) An Orange box means you need to derive what goes here by use of an Excel formula. 4) A Green box already has formulas and will update automatically as you complete the other areas. 5) A Grey box of any shade you need not do anything. Some of the info is FYI. 6) Explain three things: a) How did you choose your discount rate? b) Should you make this investment? Why? c) What other considerations do you feel are relevant in assessing the results of your work? A C D F H 1 NPV Assignment Version #4 2 3 Investment Information: 4 Initial Investment= $0 Discount Rate 0.0% Opportunity cost (if any)= Lifetime of the investment NA Cost of Borrowing 7.5% 6. Cost of Equity 15.0% 7 Salvage Value at end of project= $0 Debt to Equity NA 11 12 Year# 13 1 2 4 14 15 Investment 16 17 Incremental Revenue 2$ 2$ 18 Variable expenses 19 Fixed Expenses 20 EBITDA 21 Deductible Depr. Exp #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 22 EBIT #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 23 Tax rate 40% 40% 40% 40% 40% 24 Taxes #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 25 Net Cash Flows 2$ #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 26 27 PV of Cash Flows $4 2$ 2$ 24 24 28 Cumulative PV of NCF 2$ $4 2$ 2$ $4 29 Investment Measures: 30 NPV 31 IRR Lancers, Ltd. is contemplating a $350,000 investment of equipment that they feel can add $90,000 in revenues in Year #1 and Year #2, and $100,000 in revenue in Year 3, and $105,000 in Years 4 & 5. They estimate variable expenses at 7.5% of Sales and additional fixed costs would be approximately $9,500 per year. The equipment should last 5 years and have a salvage value of $15,000 at the end of its life. They've decided to use straight line depreciation over the equipment life. Instructions: 1) Complete the above worksheet using the information provided in the Scenario at the top right. 2) A Yellow box means you need to insert numbers either hard coded or via a simple formula. 3) An Orange box means you need to derive what goes here by use of an Excel formula. 4) A Green box already has formulas and will update automatically as you complete the other areas. 5) A Grey box of any shade you need not do anything. Some of the info is FYI. 6) Explain three things: a) How did you choose your discount rate? b) Should you make this investment? Why? c) What other considerations do you feel are relevant in assessing the results of your work? A C D F H 1 NPV Assignment Version #4 2 3 Investment Information: 4 Initial Investment= $0 Discount Rate 0.0% Opportunity cost (if any)= Lifetime of the investment NA Cost of Borrowing 7.5% 6. Cost of Equity 15.0% 7 Salvage Value at end of project= $0 Debt to Equity NA 11 12 Year# 13 1 2 4 14 15 Investment 16 17 Incremental Revenue 2$ 2$ 18 Variable expenses 19 Fixed Expenses 20 EBITDA 21 Deductible Depr. Exp #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 22 EBIT #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 23 Tax rate 40% 40% 40% 40% 40% 24 Taxes #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 25 Net Cash Flows 2$ #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! 26 27 PV of Cash Flows $4 2$ 2$ 24 24 28 Cumulative PV of NCF 2$ $4 2$ 2$ $4 29 Investment Measures: 30 NPV 31 IRR
Expert Answer:
Related Book For
Introductory Financial Accounting for Business
ISBN: 978-1260299441
1st edition
Authors: Thomas Edmonds, Christopher Edmonds
Posted Date:
Students also viewed these finance questions
-
Use Formula 2 to derive Formula 7 from Formula 8.2.5 for the case in which the curve can be represented in the form y = F(x), a < x < b.
-
Revenues Variable cost Fixed Expenses Gross profit Depreciation Net operating income Income tax expense Net income
-
Liberals and Realists present different views on the impact of economic interdependence on the likelihood of security conflict. Which view do you think is more reasonable and why?
-
EG Corporation redeemed 200 shares of stock from one of its shareholders in exchange for $200,000. The redemption represented 20% of the corporation's outstanding stock. The redemption was treated as...
-
What are the major ways in which the supply of money can change? If it is that simple, why couldnt the Fed effectively control the money supply in the past?
-
How are qualified dividends taxed in 2014? Please give the three rates of tax which apply to qualified dividends, and specify when each of these rates applies....
-
How many forms of main() are there?
-
Assume that you have selected a random sample of 15 checks from a population of 800 checks. The checks you have selected are the following numbers: 664, 789, 650, 136, 365, 538, 800, 657, 110, 136,...
-
What are some business benefits of adopting the relational database model within an organization? How does a relational model create or enhance business value? Are there any limitations to using a...
-
Using lab 7 with a three-day lead time (all original values), we will analyze six different scenarios to determine which would be the best scenario based on the total cost. Scenario A - Min is 3,500...
-
A sample have BCC structure, in X-ray diffraction. Which of the following peak will not be observed? O (112) O (222) O (111) O (422)
-
Margot is meeting with her insurance agent, Luke. Margot is young and healthy and feels this is a good time to apply for life insurance. She has a family history of cancer and understands the...
-
Steve is asked to provide a cost estimate for a redecorating project. How should he proceed? Question 31 options: Add raw materials and labor costs for each activity in the WBS. Check competitor...
-
What monthly payment is required to amortize a loan of$40,000over13years if interest at the rate of5%/year is charged on the unpaid balance and interest calculations are made at the end of each...
-
What, according to the Health Belief Model, influences the likelihood that an individual can change an unhealthy behavior?
-
Pete's Pizza deposits $5800 at the end of each quarter for 4 years. (a) Find the final amount on deposit if the money earns 6.4% compounded quarterly.
-
The long tail is a phenomenon whereby firms can make money by: selling the same product at different prices with only minor tweaks in their design. leveraging customers to promote their products or...
-
suppose a nickel-contaminated soil 15 cm deep contained 800 mg/kg Ni, Vegetation was planted to remove the nickel by phytoremediation. The above-ground plant parts average 1% Ni on a dry-weight bas...
-
a. Why are special controls needed for cash? b. What is included in the definition of cash?
-
Rosewood Inc. experienced the following events in Year 1, its first year of operation: 1. Received $50,000 cash from the issue of common stock. 2. Performed services on account for $67,000. 3. Paid a...
-
Waddell Company had the following balances in its accounting records as of December 31, Year 1: The following accounting events apply to Waddell Companys Year 2 fiscal year: Jan. 1 Acquired $20,000...
-
Which of the following is not an inherent part of Statement on Auditing Standards, No. 99/113? 1. Greater scrutiny of the chief executive and chief financial officers personal financial condition 2....
-
Which of the following statements best describes corporate governance with respect to fraud? 1. Auditors are primarily responsible for the detection of fraud, the Board of Directors for the...
-
Which of the following is not a reason that the prevention and detection of fraud resulting from management override and collusion presents a significant challenge for the antifraud community? 1....
Study smarter with the SolutionInn App