ut of question A company is considering a project that requires an initial cost of $8,000. The project will getra net cash inflows of $100 in year one, $700 in year two, $6,000 in year three, $11,000 in year four en sam in year five. What is the NPV using 4% as the discount rate? NOTE: Enter amounts rounded to two decimals (e.g., 78.76 or 40.00) Net Cash Inflow Year 0 2 3 5 $100 $700 $6,000 $11,000 $12,000 NPV Total $

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
**Project Analysis: Net Present Value Calculation**

A company is considering a project that requires an initial cost of $8,000. The project will generate after-tax net cash inflows of $100 in year one, $700 in year two, $6,000 in year three, $11,000 in year four, and $12,000 in year five. What is the NPV using 4% as the discount rate?

**NOTE:** Enter amounts rounded to two decimals (e.g., 78.76 or 40.00).

| Year | Net Cash Inflow | PV |
|------|-----------------|----|
| 0    | $100            |    |
| 1    | $700            |    |
| 2    | $6,000          |    |
| 3    | $11,000         |    |
| 4    | $12,000         |    |
| 5    |                 |    |
|      | NPV Total       |    |

To calculate NPV, use the following formula for each year:

\[
PV = \frac{\text{Net Cash Inflow}}{(1 + r)^t}
\]

where \(r\) is the discount rate (4% or 0.04) and \(t\) is the year. Then, sum all the present values and subtract the initial investment amount to calculate the NPV.

The table above outlines the project details with columns for each year, corresponding net cash inflows, and placeholders for the Present Value (PV) calculations.

This section is followed by the calculation of NPV (Net Present Value) for the project considering the provided data.
Transcribed Image Text:**Project Analysis: Net Present Value Calculation** A company is considering a project that requires an initial cost of $8,000. The project will generate after-tax net cash inflows of $100 in year one, $700 in year two, $6,000 in year three, $11,000 in year four, and $12,000 in year five. What is the NPV using 4% as the discount rate? **NOTE:** Enter amounts rounded to two decimals (e.g., 78.76 or 40.00). | Year | Net Cash Inflow | PV | |------|-----------------|----| | 0 | $100 | | | 1 | $700 | | | 2 | $6,000 | | | 3 | $11,000 | | | 4 | $12,000 | | | 5 | | | | | NPV Total | | To calculate NPV, use the following formula for each year: \[ PV = \frac{\text{Net Cash Inflow}}{(1 + r)^t} \] where \(r\) is the discount rate (4% or 0.04) and \(t\) is the year. Then, sum all the present values and subtract the initial investment amount to calculate the NPV. The table above outlines the project details with columns for each year, corresponding net cash inflows, and placeholders for the Present Value (PV) calculations. This section is followed by the calculation of NPV (Net Present Value) for the project considering the provided data.
**Project Analysis**

An educational examination of Net Present Value (NPV) calculation using a practical example:

**Project Investment and Cash Inflows:**
- **Initial Cost:** $8,000
- **Year 1 Cash Inflow:** $100
- **Year 2 Cash Inflow:** $700
- **Year 3 Cash Inflow:** $6,000
- **Year 4 Cash Inflow:** $11,000
- **Year 5 Cash Inflow:** $12,000

*Calculate the NPV using a discount rate of 4%.*

| Year | Net Cash Inflow | PV (Present Value) |
|------|-----------------|--------------------|
| 0    | -$8,000         |                    |
| 1    | $100            |                    |
| 2    | $700            |                    |
| 3    | $6,000          |                    |
| 4    | $11,000         |                    |
| 5    | $12,000         |                    |

**NOTE:** Enter amounts rounded to two decimals (e.g., 78.16 or 40.00).

**Graph Explanation:**
The table illustrates the year-wise breakdown of expected net cash inflows and the initial project cost. For each year from 0 to 5, it specifies the net cash inflow and provides a column to record the present value (PV) for each cash inflow at the 4% discount rate. The PV column is intended to help with the NPV calculation by applying the formula for discounting future cash flows.

To complete the exercise, calculate the present value for each cash inflow using the formula: PV = Cash Inflow / (1 + r)^t, where:
- PV is the Present Value,
- Cash Inflow is the cash inflow for the respective year,
- r is the discount rate (4% or 0.04),
- t is the year.

Finally, sum the present values of the cash inflows and subtract the initial cost to determine the NPV.
Transcribed Image Text:**Project Analysis** An educational examination of Net Present Value (NPV) calculation using a practical example: **Project Investment and Cash Inflows:** - **Initial Cost:** $8,000 - **Year 1 Cash Inflow:** $100 - **Year 2 Cash Inflow:** $700 - **Year 3 Cash Inflow:** $6,000 - **Year 4 Cash Inflow:** $11,000 - **Year 5 Cash Inflow:** $12,000 *Calculate the NPV using a discount rate of 4%.* | Year | Net Cash Inflow | PV (Present Value) | |------|-----------------|--------------------| | 0 | -$8,000 | | | 1 | $100 | | | 2 | $700 | | | 3 | $6,000 | | | 4 | $11,000 | | | 5 | $12,000 | | **NOTE:** Enter amounts rounded to two decimals (e.g., 78.16 or 40.00). **Graph Explanation:** The table illustrates the year-wise breakdown of expected net cash inflows and the initial project cost. For each year from 0 to 5, it specifies the net cash inflow and provides a column to record the present value (PV) for each cash inflow at the 4% discount rate. The PV column is intended to help with the NPV calculation by applying the formula for discounting future cash flows. To complete the exercise, calculate the present value for each cash inflow using the formula: PV = Cash Inflow / (1 + r)^t, where: - PV is the Present Value, - Cash Inflow is the cash inflow for the respective year, - r is the discount rate (4% or 0.04), - t is the year. Finally, sum the present values of the cash inflows and subtract the initial cost to determine the NPV.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education