Answered step by step
Verified Expert Solution
Question
1 Approved Answer
help needed with cash flow excel TextBox 1 F 1 B D E A company has a minimum required rate of return of 11 2
help needed with cash flow excel
TextBox 1 F 1 B D E A company has a minimum required rate of return of 11 2 % and is considering investing in a project that costs $225,000 and is 3 expected to generate cash inflows of $110,000 at the end of each year for three years. The net present value of this project is 5 4 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 Together Net Annual Cash Flow NPV On Your Own 1 NPVC E B D 1 ABC Company has two capital Investment opportunities and estimates are given below 2 Project Alpha Project Beta 3 Initial Investment 500,000 750,000 4 Annual Net Income 45,000 80,000 5 Net Annual Cash Inflow 110,000 150,000 6 Estimated Useful Life (Years) 5 7 7 Salvage Value 8 9 The company Requires a 12% Rate of return 10 11 Calculate Present Value of Project Beta? 12 13 14 15 16 E B D 1 You have been hired as an analyst at ABC company and asked to calculate 2 the financial feasibility of the following project. 3 ABC Company invests $250,000 in new machinery. They are expected to receive 4 net annual cash flows of $35,000 for 10 years with an interest rate of 8%.. 5 6 1) Calculate PV of Cash Flows? 7 2) Calculate NPV of Investment and decide if it would be a good investment? 8 3) What other considerations should an analyst take into consideration other than just financial impact? 9 10 Capital Investment 11 Net Annual Cash Flows 12 Annuity Payments 13 Intererst Rate 14 Table Factor 15 1) Calculate Present Value 16 1) Calculate Using Financial Calculator 17 2) Calculate Using MS Excel 18 19 2) Calculate NPV 20 Present Value of Net Annual Cash Flows 21 less Capital Investment 22 Net Present Value (NPV) 23 24 25 3) What other considerations should be looked at before investingStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started