Autolave Flo Home Insert Draw Page Layout Formulas Workbook (1) Data Review View Search(+1 X Cut...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Autolave Flo Home Insert Draw Page Layout Formulas Workbook (1) Data Review View Search(+1 X Cut Calibr 12 A A = -4 Copy- Pave BU A Format Painter 54 Unde A 1 Assignment 5-2, Question 1 Clipboard Font Wrap Text General Merge & Center $% 92 Alignment Number Sx B C D E F G H Comments Share Normal Autosum Bad Good Conditional Format as Neutral Calculation Formatting-Table- Check Cell insert Delete Format FI Sort & Find & Analyze Clear - Fiber-Select Data 16 Styles Eating Any K L M N P Q R 2 3 a. 4 5 Net Present Value (NPV): 7 NPVX- -$10,000 + S + $ $ 8 9 10 11 12 NPV- S $10,000 S $ ' $ + $ 13 14 15 Internal Rate of Return (IRR): 16 17 To solve for each project's IRR, find the discount rates that equate each NPV to zero: 18 19 20 IRR IRRY % % 21 22 23 Modified Internal Rate of Return (MIRR): 24 25 To obtain each project's MIRR, begin by finding each project's terminal value (TV) of cash inflows: 26 27 TVx 28 29 TVy - $6,500 (1.12)^3 - $ + $ + S + S + $1,000 - $ + $ + $3,500 - $ 30 31 Now, each project's MIRR is the discount rate that equates the PV of the TV to each project's cost, $10,000: 32 33 34 MIRR MIRRY = % % 35 36 37 Profitability Index (PI): 38 39 -10 - 41 -12 - 43 44 - 45 + Cost of X $10,000 - $ PVY NPVy + Cost of Y - $ + $ $ + To obtain each project's Pl, divide its present value of future cash flows by its initial cost. The PV of future cash flows can be found from the NPV calculated earlier: PVX NPVx $ 46 47 48 Plx = PVx 45 Cost of X 49 = $ + $ 50 51 Ply = 52 = PVY $ + Cost of Y $ = 53 54 55 56 57 3-1 Question 1 3-1 Question 2 3-1 Question 3 5.2 Question 1 Ready Arreseilly Investigate 115% Autolave Flo Home Insert Draw Page Layout Formulas Workbook (1) Data Review View Search(+1 X Cut Calibr 12 A A = -4 Copy- Pave BU A Format Painter 54 Unde A 1 Assignment 5-2, Question 1 Clipboard Font Wrap Text General Merge & Center $% 92 Alignment Number Sx B C D E F G H Comments Share Normal Autosum Bad Good Conditional Format as Neutral Calculation Formatting-Table- Check Cell insert Delete Format FI Sort & Find & Analyze Clear - Fiber-Select Data 16 Styles Eating Any K L M N P Q R 2 3 a. 4 5 Net Present Value (NPV): 7 NPVX- -$10,000 + S + $ $ 8 9 10 11 12 NPV- S $10,000 S $ ' $ + $ 13 14 15 Internal Rate of Return (IRR): 16 17 To solve for each project's IRR, find the discount rates that equate each NPV to zero: 18 19 20 IRR IRRY % % 21 22 23 Modified Internal Rate of Return (MIRR): 24 25 To obtain each project's MIRR, begin by finding each project's terminal value (TV) of cash inflows: 26 27 TVx 28 29 TVy - $6,500 (1.12)^3 - $ + $ + S + S + $1,000 - $ + $ + $3,500 - $ 30 31 Now, each project's MIRR is the discount rate that equates the PV of the TV to each project's cost, $10,000: 32 33 34 MIRR MIRRY = % % 35 36 37 Profitability Index (PI): 38 39 -10 - 41 -12 - 43 44 - 45 + Cost of X $10,000 - $ PVY NPVy + Cost of Y - $ + $ $ + To obtain each project's Pl, divide its present value of future cash flows by its initial cost. The PV of future cash flows can be found from the NPV calculated earlier: PVX NPVx $ 46 47 48 Plx = PVx 45 Cost of X 49 = $ + $ 50 51 Ply = 52 = PVY $ + Cost of Y $ = 53 54 55 56 57 3-1 Question 1 3-1 Question 2 3-1 Question 3 5.2 Question 1 Ready Arreseilly Investigate 115%
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
On March 31, 2019, the balances of the accounts appearing in the ledger of Racine Furnishings Company, a furniture wholesaler, are as follows: a. Prepare a multiple-step income statement for the year...
-
The following structure is that of an L aldohexoses in its pyranose form. Identify it, and tell whether it is an ? a or ? anomer.
-
Accents Furniture Company has been in business for two years. When the business began, Accents established a delivery department with a small fleet of trucks. The delivery department was designed to...
-
When a bond is issued at a discount, the interest expense each year a. is greater than the cash payment for interest. b. is less than the cash payment for interest. c. equals the cash payment for...
-
Tidal Corporation was organized on January 1, 2017. It is authorized to issue 20,000 shares of 6%, $50 par value preferred stock and 500,000 shares of no-par common stock with a stated value of $1...
-
Find the polynomial of the specified degree whose graph is shown. Degree 4 P(X) = 12 10 8 6 4 2 -4 2 -1 1 2 3 4 X 2
-
Reread the SECs 2003 interpretation (from the passage below). In your own words, explain the difference between integrated hardware and software control codes and software applications that use...
-
In 2023, Comet Corporation sold farm land for $500,000. Comet originally had acquired the land for $400,000 several years ago. Previously, Comet had reported the following gains and losses on Section...
-
Consider the two securities, X and Y. The expected returns and standard deviations for the two securities are shown in Table 1 below. Table 1: Expected return and standard deviation of return for X...
-
Company X needs to find a new financing for EUR 2 Mio. What kind of financing source management can have ( please give 2 options only ) . Prepare the accounting journal entries for each of the 2...
-
What is the difference between future value and present value? What data do you need to future value or present value calculation?What are various ways to calculate the time value of money in...
-
Discuss the potential of metal-organic frameworks (MOFs) and covalent organic frameworks (COFs) as emerging catalysts, focusing on their unique structural properties and potential applications in...
-
A company sells 10 Jonah Cigars for $59/each. The variable cost is $19, and the fixed cost is $100. The company has G&A costs of $120 and has a tax rate of 10%. Answer the following: 21. The Net...
-
Suppose that the laptop of Prob. 2.16 is placed in an insulating briefcase with a fully charged battery, but it does not go into sleep mode, and the battery discharges as if the laptop were in use....
-
Explain internal control procedures for merchandise sales. - Since sales revenues have a significant effect on a company's net income, internal control procedures must be established to ensure that...
-
Measure and report net sales revenue. - The appropriate amount of revenue to recognize is generally the cash received or the cash equivalent of accounts receivable. - However, companies often induce...
-
Measure and report bad debt expense and the allowance for doubtful accounts. - The primary issues in accounting for accounts receivable are when and how to measure bad debts (i.e., accounts that will...
Study smarter with the SolutionInn App