Calculate the NPV and IRR

Assignment Help Financial Accounting

Reference no: EM13789114

Using a spreadsheet program like Excel, calculate the NPV and IRR of the following scenario:

Cost (Year 0): 10,000.

Year 1 Return: 3,000.

Year 2 Return: 3,000.

Year 3 Return: 5,000.

Discount Rate: 10%.

Reference no: EM13789114

Questions Cloud

Concerned about with respect to individual entries : The Audit Committee of a small manufacturing company that sells its products globally has directed internal audit to perform specific annual reviews to monitor manual journal entries, with a particular focus on potential management override activitie..

Programmatic discipline or professional : You will present to your peers as assigned by your instructor, using the discipline-related topic determined by your previous outline.

The energy policy act of 2005 : Explain how these scientific laws apply to energy use, energy conversions, and the need for energy efficiency.

Assumptions and the effects of possible changes in values : Assume you are working as an investment financial officer for your company (or use a public company of your choice). Make up an investment opportunity for your company and discuss key sensitivities (risks) and possible scenarios. Discuss a few risks ..

Calculate the NPV and IRR : Using a spreadsheet program like Excel, calculate the NPV and IRR of the following scenario:

Stockholders equity at the end of the year : Jimmy’s Repair Shop started the year with total assets of $200,000 and total liabilities of $160,000. During the year the business recorded $420,000 in revenues, $220,000 in expenses, and dividends of $40,000. Stockholder’s equity at the end of the y..

Recorded revenues-expenses-paid dividends : Henson Company began the year with retained earnings of $330,000. During the year, the company recorded revenues of $500,000, expenses of $380,000, and paid dividends of $40,000. What was Henson’s retained earnings at the end of the year?

Discuss the various uses of public budget : From what you have learnt so far, briefly explain the key responsibilities of public administrators and the best way of meeting the responsibilities. Discuss the various uses of public budget

Discuss the concept of a social bond : You should utilise the materials and skills you have acquired from the three writing tutorials to ensure your essay meets the standards required of first year academic writing.

User Account

All Pages