There is a possibility that Edward can invest in another set of equipment which costs $70,000...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
There is a possibility that Edward can invest in another set of equipment which costs $70,000 less but which will generate revenues of only $200,000 in the first year, with the rest of the cost structure staying the same as described above. He still believes that he can get bank financing for 75% of the assets including working capital over a seven-year period at an APR of 7% compounded monthly. He plans to put in the rest of the money with a loan from his family, which he will pay back in 10 equal yearly installments with no interest. If Edward estimates that the business can be sold at the end of the 10-year period for $700,000: Explain in an excel a. What will be the IRR for the project? b. What will be the NPV for his investment if the MARR was 11%? c. What will be the EUAB that the business will be able to generate over the 10-year period? d. What is the Delta IRR of the original scenario over this one? e. Should Edward go in for this scenario rather than the original one at an MARR of 11%? There is a possibility that Edward can invest in another set of equipment which costs $70,000 less but which will generate revenues of only $200,000 in the first year, with the rest of the cost structure staying the same as described above. He still believes that he can get bank financing for 75% of the assets including working capital over a seven-year period at an APR of 7% compounded monthly. He plans to put in the rest of the money with a loan from his family, which he will pay back in 10 equal yearly installments with no interest. If Edward estimates that the business can be sold at the end of the 10-year period for $700,000: Explain in an excel a. What will be the IRR for the project? b. What will be the NPV for his investment if the MARR was 11%? c. What will be the EUAB that the business will be able to generate over the 10-year period? d. What is the Delta IRR of the original scenario over this one? e. Should Edward go in for this scenario rather than the original one at an MARR of 11%?
Expert Answer:
Answer rating: 100% (QA)
To calculate the financial metrics for the two investment scenarios we need to set up a cash flow an... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1337614689
9th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these accounting questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Shawn and Susan loved rock climbing. Once they turned 19, they left Vancouver and travelled around the world living in their RV. They worked as nurses in the communities they happened to be in at a...
-
Your preparer tax identification number (PTIN) is PO0389571. Your Firm ik For) Jones and Miller's address is 230 Hollister Avenue - San Francisco, CA 94131 and its phone number is (650) 686-7777....
-
A 1.0 m long metallic rod is rotated with an angular frequency of 400 rad s about an axis normal to the rod passing through its one end. The other end of the rod is in contact with a circular...
-
Identifying Expenses The following transactions are July 2011 activities of Craigs Bowling, Inc., which operates several bowling centers (for games and equipment sales). If expense is to be...
-
Which of the following statements are true? Select the three correct answers. (a) The condition in an if statement can have method calls. (b) If a and b are of type boolean or Boolean, the expression...
-
Discuss the themes, theory, and/or phenomenon that would be anticipated to emerge as a result of the examination. Develop a hypothetical research scenario that would necessitate the use of the Action...
-
Marvin's Kitchen Supply delivers restaurant supplies throughout the city. The firm adds 10 percent to the cost of the supplies to cover the delivery cost. The delivery fee is meant to cover the cost...
-
1. Convert the following iteration Even method to recursive method: (Ex: EVEN(0,10) Void enas iteration even(int Lint n) { } int i=1: while(i
-
In this mini-case, you will complete the test of details on accounts receivable for the 2019 audit of EarthWear Clothiers, Inc. The principal test of detail involves sending "confirmations" or...
-
B made an issue of 150,000 $1 ordinary shares at a premium of 20% the proceeds of which is received by cheque. What is the correct journal to record this? A. Bank Share capital Share premium B. Bank...
-
The following budgeted profit statement has been prepared using absorption costing principles. The members of the management team are concerned by the significant change in profitability between the...
-
The most recent financial statements for Bradley, Inc., are shown here (assuming no income taxes): Income Statement Sales $ 9,000 Costs (6,750 ) Net income $ 2,250 Balance Sheet Assets $ 28,800 Debt...
-
1. explain how inference combined with empathy and humility are key characteristics of critical thinking. 2. List one way in which context may affect the critical thinking process. 1. Identify the...
-
a Controller MainController that - has a playerDB class injected into it - has a mapping for "/players" that returns a 'players' template and attaches all players to the model a Controller...
-
Consider a 5-year, $1000 bond with a 2.2% coupon rate and semiannual coupons. If YTM = 3%APR, what is its price?
-
XE7-24 (similar to) Question Help The Sodus Company produces engine parts for car manufacturers. A new accountant intern at Sodus has accidentally deleted the calculations on the company's variance...
-
Arlington Merchants reported the following on its income statement for the fiscal years ending December 31, 2016 and 2015. 2016 2015 Sales $4,857,500 $4,752,900 Cost of goods sold 3,258,950 3,207,000...
-
Part A Walmart Stores (Walmart) is the world's largest retailer. It employs an ''everyday low price'' strategy and operates stores as three business segments: Walmart Stores U.S., International, and...
-
Explain the theory behind the free cash flows valuation approach. Why are free cash flows value-relevant to common equity shareholders when they are not cash flows to those shareholders, but rather...
-
Exhibits 1.191.21 of Integrative Case 1.1 (Chapter 1) present the financial statements for Walmart for 20122015. In addition, the website for this text contains Walmarts December 31, 2015, Form 10-K....
-
Let \(F: \mathbb{R} ightarrow[0,1]\) be a distribution function. a) Show that there exists a probability space \((\Omega, \mathscr{A}, \mathbb{P})\) and a random variable \(X\) such that...
-
Let \(\left(B_{t}ight)_{t \geqslant 0}\) be a \(\mathrm{BM}^{d}\) and assume that \(X\) is a \(d\)-dimensional random variable which is independent of \(\mathscr{F}_{\infty}^{B}\). a) Show that...
-
Let \(\left(B_{t}, \mathscr{F}_{t}ight)_{t \geqslant 0}\) be a one-dimensional Brownian motion. Which of the following processes are martingales? a) \(U_{t}=e^{c B_{t}}, c \in \mathbb{R}\); b)...
Study smarter with the SolutionInn App