Make notes and and proceed with calculations in Exel (calculate missed numbers, highlighted in yellow) then construct
Fantastic news! We've Found the answer you've been seeking!
Question:
Make notes and and proceed with calculations in Exel (calculate missed numbers, highlighted in yellow) then construct NPV profiles for projects.
Transcribed Image Text:
КОРЕНЬ •x fx =A28+43% 1 2 5 Discount Rate 7 8 Upgrade 9 Cash flows 10 Sum of cash flows 11 Net present value (NPV) 12 Internal rate of return (IRR) 13 14 Hoophouse 15 Cash flows 16 Sum of cash flows 17 Net present value (NPV) 18 Internal rate of return (IRR) 19 A 20 Hoophouse rather than upgrade 21 Cash flows (hoophouse minus upgrade) 22 Sum of cash flows 23 Net present value (NPV) 24 Internal rate of return (IRR) 25 26 NPV Profiles 27 26 29-A28+4% 30 31 32 33 Exhibit TN4 Hightrek Inc. Alternative Investment Facility Upgrade 15%1 B 23% 27% 31% 35% 15% Year 0 -100 000 -100 000 -100 000 число! -100 000 -92060 -91 866 ЧИСЛО! Data Table Year 1 -100 000 -100 000 -100 000 -100 000 -100 000 -100 000 -100 000 12070 12 070 0 7940 8134 -30,06% [This is the break-even discount rate.] -91.866 -91 866 -91 917 -91 991 -92 084 D -92 189 -92 303 Year 2 0 Cost of capital 0 15% 19% 23% 27% 31% 35% E Year 3 0 Upgrade 0 Data for Graph -100 000 -100 000 Year 4 -100 000 -100 000 -100 000 -100 000 4130 4130 Hoophouse -91 866 -92 303 G 86000 -88 000 90 000 42 000 -M4000 -96 000 -18 000 -100 000 -102 000 H 1 1 K L 15,00% 19,00% 23,00% 27,00% 31,00% 35,00% M Upgrade -Hophose КОРЕНЬ •x fx =A28+43% 1 2 5 Discount Rate 7 8 Upgrade 9 Cash flows 10 Sum of cash flows 11 Net present value (NPV) 12 Internal rate of return (IRR) 13 14 Hoophouse 15 Cash flows 16 Sum of cash flows 17 Net present value (NPV) 18 Internal rate of return (IRR) 19 A 20 Hoophouse rather than upgrade 21 Cash flows (hoophouse minus upgrade) 22 Sum of cash flows 23 Net present value (NPV) 24 Internal rate of return (IRR) 25 26 NPV Profiles 27 26 29-A28+4% 30 31 32 33 Exhibit TN4 Hightrek Inc. Alternative Investment Facility Upgrade 15%1 B 23% 27% 31% 35% 15% Year 0 -100 000 -100 000 -100 000 число! -100 000 -92060 -91 866 ЧИСЛО! Data Table Year 1 -100 000 -100 000 -100 000 -100 000 -100 000 -100 000 -100 000 12070 12 070 0 7940 8134 -30,06% [This is the break-even discount rate.] -91.866 -91 866 -91 917 -91 991 -92 084 D -92 189 -92 303 Year 2 0 Cost of capital 0 15% 19% 23% 27% 31% 35% E Year 3 0 Upgrade 0 Data for Graph -100 000 -100 000 Year 4 -100 000 -100 000 -100 000 -100 000 4130 4130 Hoophouse -91 866 -92 303 G 86000 -88 000 90 000 42 000 -M4000 -96 000 -18 000 -100 000 -102 000 H 1 1 K L 15,00% 19,00% 23,00% 27,00% 31,00% 35,00% M Upgrade -Hophose
Expert Answer:
Answer rating: 100% (QA)
Based on the information provided here are the calculations and notes you can make in Excel Calculat... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Construct a scatter plot for each data set. Then calculate r and r2 for each data set. Interpret their values. a. b. c. d. x2 1 0 2 |-2125 x -2 -1 0 2 1 22 3 3 3 4
-
Calculate the IRR and NPV for the following two investment opportunities. Assume a 16 percent discount rate for the NPV calculations: Year Project 2 Cash Flow S10,000 1.000 Project 1 Cash Flow...
-
Calculate the IRR, NPV, and PI for projects with the following cash flows. Do each NPV and PI calculation at costs of capital of 8% and 12%. Calculate IRRs to the nearest whole percent. a. An initial...
-
After assembly, a finished TV is left turned on for one full day (24 h) to determine whether the product is reliable. On average, two TVs break down each day. Yesterday 500 TVs were produced. What is...
-
Formulate the linear programming model, develop a spreadsheet, and solve the capital rationing problem in Example (a) As presented (b) Using an investment limit of $13 million.
-
Zachary Griggs, then 11 months old, sustained serious injuries in a fire at his Pennsylvania home that his three-year-old stepbrother, Kenneth Hempstead, ignited with a disposable butane lighter...
-
Suppose that the current measurements in a strip of wire are assumed to follow a normal distribution with a mean of 10 milliamperes and a variance of 4 (milliamperes) \({ }^{2}\). What is the...
-
One item is omitted in each of the following summaries of balance sheet and income statement data for four different corporations, East, North, South, and West. Determine the missing amounts,...
-
Ethical Finance brings Value to Society, do you think Islamic finance also brings value to society? What are the Islamic social financing channels?
-
Answer these questions, based on the debit memorandum shown here. 1. Which company is returning the merchandise? 2. How many items are being returned? 3. What amount is entered in the journal entry?...
-
A warehouse layout is to be designed, given that Storage bays are of size 15 m X 10 m each. Docks P 1 is for truck delivery docks P2, P 3 and P4 are for rail delivery Dedicated storage is used....
-
Express how an American firm could utilize hedging tools to mitigate foreign exchange exposure in France.
-
Risk-Free Rate Economy Condition Catastrophic 0.10% Probability Stock A Stock B Stock C Stock D 2.10% -60.15% -24.50% -2.15% -1.50% Bad 31.25% -12.55% -7.15% 1.30% -1.00% Neutral 38.90% 3.45% 0%...
-
A risky portfolio pays a 15% rate of return with probability 60% in a good state or a 5% return with probability 40% in a bad state, and a T-bill pays 5%. What is the risk premium on the risky...
-
a. Consider the following FI balance sheet (in millions): Assets Liabilities Liquid assets $20 Deposits $1,800 Loans 2,550 Property 330 Interbank borrowings Equity ? 150 Questions a. If stable core...
-
Discuss the impact of environmental stressors, such as temperature fluctuations, nutrient availability, and chemical exposures, on meiotic chromosome dynamics, recombination frequency, and gamete...
-
Red Hen PTY. LTD. purchased $9,200 worth of steam cleaning services from Chooka's Steam Cleaning Services. The owner of Chooka's Steam Cleaning Services purchased 20 kilograms of Chicken salt from...
-
Players A, B, and C toss a fair coin in order. The first to throw a head wins. What are their respective chances of winning?
-
Olinde Electronics, Inc., produces stereo components that sell for $100. Olindes fixed costs are $200,000; the firm produces and sells 5,000 components each year; EBIT is currently $50,000; and...
-
What types of companies enter the markets for initial public offerings? Why do companies choose to go public? Why not stay private?
-
The Niendorf Corporation produces tea kettles, which it sells for $15 each. Fixed costs are $700,000 for output up to 400,000 units. Variable costs amount to $10 per kettle. a. What is the firms gain...
-
If, during a stride, the stretch causes her center of mass to lower by \(10 \mathrm{~mm}\), what is the stored energy? A. \(3.0 \mathrm{~J}\) B. \(6.0 \mathrm{~J}\) C. \(9.0 \mathrm{~J}\) D. \(12...
-
A \(1.00 \mathrm{~kg}\) block is attached to a horizontal spring with spring INT constant \(2500 \mathrm{~N} / \mathrm{m}\). The block is at rest on a frictionless surface. A \(10.0 \mathrm{~g}\)...
-
We can make a static measurement to deduce the spring constant to use in the model. If a \(61 \mathrm{~kg}\) woman stands on a low wall with her full weight on the ball of one foot and the heel free...
Study smarter with the SolutionInn App