Question

Question 2: Calculate the Payback Period. Shall investment be accepted target payback period is 3 years? (25 marks) Question


PART II: (Total Marks 50) Project: BARBELLE LADIES CLUB Expansion BARBELLE LADIES CLUB Company is planning to open a new bran
0 0
Add a comment Improve this question Transcribed image text
Answer #1
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

Add a comment
Know the answer?
Add Answer to:
Question 2: Calculate the Payback Period. Shall investment be accepted target payback period is 3 years?...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

    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...

    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....

    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...

    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...

  • 1. Determine the payback period for an investment. 2. Evaluate the acceptability of an investment...

    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 ...

    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...

    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...

    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....

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT