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 is the firms objective with regard to collection float?
-
Futuristic Electronic Center began October with 65 units of merchandise inventory that cost $82 each. During October, the store made the following purchases: Oct. 3 ................... 25 units @ $...
-
On April 14, 2006, The Wall Street Journal carried an article headlined Research in Motion Skeptics Pipe Up. The article concerned Research in Motion Ltd. (RIM), the manufacturer of the BlackBerry....
-
Tescott Company and Heizer Company both apply overhead to the Work in Process Inventory account using direct labor hours. The following information is available for both companies for the year:...
-
Using Walmart 10 k Report link below https://s201.q4cdn.com/262069030/files/doc financials/2023/ar/Walmart-10K-Reports-Optimized.pdf Financial Results fROM WALMART 10 k REPORT FOR THE FOLLOWING...
-
a. Find the shortest path from A to all other vertices for the graph in Figure 9.82. b. Find the shortest unweighted path from B to all other vertices for the graph in Figure 9.82. 3 D 3. 2.
-
John walks to the bus station where he catches a bus ride to work every day. Every day on his walks, John passes a house from where there invariably emanates an extremely loud noise that disturbs him...
-
The dissenting Justices in Obergefell claimed that the plaintiffs were not seeking to "exercise the right to marry," but were instead seeking to exercise a novel and nonexistent right to enter into...
-
What did the Supreme Court say in Palmore about the role of race in custody disputes?
-
How did the Protestant view of marriage differ from the Catholic Church's? What impact did this have on divorce law?
-
What is a lien, and what role does it have in the child support context?
-
What remedies were available from the ecclesiastical courts for an unhappy marriage?
-
Answer each question to the best of your ability. Show your calculations (they can be verified on a calculator). Your final answer should be in the form of a complete sentence. 1. In testing a method...
-
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...
-
The basic concept behind a learning organization is: A. The popularity to change. B. The people change. C. The adaptation to change. D. The resources of change.
-
Which theory emphasizes the importance of cooperation and participation in the workplace? A. Chaos Theory. B. Systems Theory. C. Classical Theory. D. Neoclassical Theory.
-
Line and staff positions are identified on the organization chart. What does the line position denote? A. Who is responsible to whom within the organization. B. Advisory relationships between...
Study smarter with the SolutionInn App