Gadubhai Compute the payback period for an investment with the following net cash flows. (Round your answer to one decimal place.)YearInitial investment1.2.3.4.5.6.Net Cash Flowsper Year$ (114,000)Cumulative NetCash Flows$ (114,000)11,40021,400(102,600)(81,200)21,400(59,800)39,100(20,700)41,40020,70041,40062,100Payback periodyears

Calculate the payback period of the investment using Excel as follows:Formula sheet:Note:To…

Answered: Compute the payback period for an…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Compute the payback perlod for an Investment with the following net cash flows. (Round your answer to one decimal place.) Net Cash Flows per Year Cumulative Net Cash Flows $ (101,000) $ (101,000) (90,900) (70,800) Year Initial investment 1. 2. 3. 5. 6. Payback period 10,100 20,100 20,100 26,640 40,100 40,100 years (50,700) (24,060) 16,040 56,140
Compute the payback period for an investment with the following net cash flows (Round your answer to one decimal place.) Net Cash Flows per Year $ (115,000) 11,000 21,000 21,000 2. 3. 4. Year 41,000 years Cumulative Net Cash Flows $ (118,000) (105,200) (84,400) (62,000) (37,620) 4,100 45,900
Calculate the EAR of the following investment, entered as a percentage (Example: if your answer is 0.145, enter 14.5) Year Number Cashflow 0 -11400 1 3500 2 3000 3 3100 4 2800 Your Answer:
Calculate the internal rates of return of the following investment: Net investment -$1,100 Year 0 Net cash flows +6,500 Year 1 -11,400 Year 2 +6,000 Year 3 Round your answers to the nearest whole number and enter them in ascending order. IRR1: 0% IRR2: % IRR3: %
For the investment shown in the following table, calculate the rate of return earned over the unspecified time period. Cash flow during period Beginning-of- period value End-of- period value $370 $42,400 $36,500 The rate of return on the investment is enter your response here%
Calculate the HPR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Period Cashflow 0 -14100 1 3300 2 3300 3 3100 4 2800
For the investment shown in the following table, calculate the total return earned over the unspecified time period. Cash flow during period Beginning-of- period value End-of- period value −$10 $3,200 $2,800 The total return on the investment is __%.
A project has the following cash flows set out below. What is the profitability index of this project if the relevant discount rate is 2 percent? Enter your final answer to two decimal places. Year Cash flow 0 -1,745 1 537 2 2,066 3 3,912
Mendez Company has identified an investment project with the following cash flows. Year 1 Cash Flow $870 1,230 234 1,490 1,650 a. If the discount rate is 10 percent, what is the present value of these cash flows? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) b. What is the present value at 20 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) c. What is the present value at 30 percent? (Do not round intermediate calculations and round your answer to 2 decimal places, e.g., 32.16.) a. Present value at 10% b. Present value at 20% c. Present value at 30%
McCann Co. has identified an investment project with the following cash flows. Year Cash Flow 1 $800 2 1,030 3 1,340 4 1,110 a If the discount rate is 10 percent, what is the present value of these cash flows? b What is the present value at 18 and 28 percent?
Calculate the APR of the following investment, entered as a percentage (Example: if your answer is 14.5%, enter 14.5 and not 0.145) Year Number Cashflow 0 -11000 1 3000 2 3500 3 2900 4 2800
For each of the investments below, calculate the rate of return earned over the period. Investment Cash Flow During Period - $300 18,000 с 5,000 D 60 E 1,500 (Click on the icon here in order to copy the contents of the data table above into a spreadsheet.) A B The rate of return on Investment A is %. (Round to two decimal places.) Beginning-of-Period End-of-Period Value Value $2,100 160,000 40,000 300 12,000 $700 113,000 45,000 100 13,200

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS