Year 0 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | ||
Investment | 850000 | ||||||
Sales | A | 400000 | 450000 | 500000 | 550000 | 550000 | |
Selling expense | B | 60000 | 65000 | 65000 | 65000 | 70000 | |
Rent expense | C | 52000 | 50000 | 55000 | 55000 | 55000 | |
Salary | D | 53000 | 55000 | 55000 | 60000 | 60000 | |
depreciation | E | 150000 | 150000 | 150000 | 150000 | 150000 | |
Net Income (A-b-c-d-e) | F | 85000 | 130000 | 175000 | 220000 | 215000 | |
Cash Flow (F+E) | G | -850000 | 235000 | 280000 | 325000 | 370000 | 365000 |
Cumulative Cash Flow | -850000 | -615000 | -335000 | -10000 | 360000 | 725000 |
Payback Period : Payback Period = A + B
C
Where,
A is the last period number with a negative cumulative cash
flow;
B is the absolute value (i.e. value without negative sign) of
cumulative net cash flow at the end of the period A; and
C is the total cash inflow during the period following period A
Payback period = 3 years + (10000/370000)
= 3.027 Years
Yes Company can invest in project
Average Accounting Return = Average Annual profit / Initial Investment
(85000+130000+175000+22000+215000) /
5
850000
= 165000 *
100
850000
= 19.41%
As return is more than 19% company can invest in the project
Question 2: Calculate the Payback Period. Shall investment be accepted target payback period is 3 years?...
Question 2: Calculate the Payback Period. Shall investment be accepted target payback period is 3 years? (25 marks) Question 3: Calculate Average Accounting Return (AAR) for the Famous Company. Shall investment be accepted if target rate of return is 19%? (15 marks) amount of money at the end of each year, caming 7% annual interest rate. How much is such a yearly annuity? (4 marks) PART II: (Total Marks = 50) Project: BARBELLE LADIES CLUB Expansion BARBELLE LADIES CLUB Company...
PART II: (Total Marks = 50) Project: BARBELLE LADIES CLUB Expansion BARBELLE LADIES CLUB Company is planning to open a new branch in Dubai. The new investment would cost AED 850,000 to invest today. These assets will last for 5 years with no salvage value. The company uses a straight-line depreciation method. Management has prepared the projected income statements for 5 years given below. Year 1 Year 2 Year 3 Year 4 Year 5 Sales 400,000 450,000 500,000 550,000 550,000...
PART II: (Total Marks = 50) Project: BARBELLE LADIES CLUB Expansion new investment would cost AED 850,000 to invest today. These assets will last for 5 years with no salvage value. The company uses a straight-line depreciation method. Management has prepared the projected income statements for 5 years given below. Year 1 Year 2 Year 3 Year 4 Year 5 Sales 400,000 450,000 500,000 550,000 550,000 Selling 60,000 65,000 65,000 65,000 70,000 expense 52,000 50,000 55,000 55,000 55,000 Rent expense...
Cash payback period, net present value method, and analysis for a service company PR 25-2B Obj. 2, 3 Social Circle Publications Inc. is considering two new magazine products. The estimated net cash flows from each product are as follows: EXCEL TEMPLATE Pro Gamer Sound Cellar Year 70,000 55,000 35,000 30,000 30,000 65,000 60,000 25,000 25,000 45,000 Total $220.000 $22000 ct requires an investment of $125,000. A rate of 10% has been selected for the Each produ net present value analysis....
Payback Period: Initial Investment Year 1 Cash Inflow Year 2 Cash Inflow Year 3 Cash Inflow Year 4 Cash Inflow Year 5 Cash Inflow Project A 100,000 10,000 10,000 20,000 30,000 30,000 Project B 200,000 50,000 60,000 90,000 60,000 60,000 In years, what is the payback period for Project A? In years, what is the payback period for Project B? Based on payback period, which project would you recommend for your company to pursue? Initial Investment 1st Year Cash Inflow...
Need help entering the answers as formulas! :) 1. Determine the payback period for an investment. 2. Evaluate the acceptability of an investment project using the net present value method 3. Evaluate the acceptability of an investment project using the internal rate of return method. 4. Compute the simple rate of return for an investment. 1 Laurman, Inc. is considering the following project: 2Required investment in equipment 3 Proiect life 4 Salvage value 2,205,000 225,000 6 The project would provide...
1. Determine the payback period for an investment 2. Evaluate the acceptability of an investment project using the net present value method 3. Evaluate the acceptability of an investment project using the internal rate of return method 4. Compute the simple rate of return for an investment Comparison of Capital Budgeting Methods Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEWVEW Alignment Number Conditional Format as Cel Cells Editing Formatting" TableStyles Cipboard A1 v | | | X | |...
determine the payback period method lysis ment is phone tower, they use cu value method, the payback period methuu, By using these methods, they can ensure a wise allocation UI TEJE time minimize the risks involved in the investment decision. LO3 Suppose that Neighborhood Communications is considering building a new cell phone tower and has gathered the following information: Purchase price $600,000 Residual value $100,000 Desired payback period 3 years 15% Minimum rate of return The cash flow estimates are...
4. CAPITAL INVESTMENT DECISIONS The following information relates to three possible capital expenditure projects. Because of capital rationing only one project can be accepted. Project A Project B Project C Initial Cost $230,000 $250,000 $190,000 Expected life 5years 5 years 4 years Scrap value expected $10,000 $15,000 $10,000 Expected Cash Inflows: $ $ $ End Year 1 85,000 95,000 45,000 End Year 2 70,000 70,000 65,000 End Year 3 65,000 55,000 95,000 End Year 4 60,000 50,000 100,000 End Year...
Problem 3-Capital Investment Russell Company is evaluating a project which will require an investment of $525,000. The project has an estimated life of 4 years and no salvage value. It is also expected to have the following net income and net cash flow Year Net Income Net Cash Flow $ 85,000 S 150,000 2 3. 4. 60,000 50,000 200,000 160,000 90,000 Russell Company's minimum desired rte of return is 12%. The present value factor of S1 at compound interest of...