Calculate the net present value (NPV) before tax of investment A: a factory. Base your calculation on the following information: The investment cost is paid in full in quarter 0, and the cost of the factory is 100000. The factory has a lifetime of 20 quarters (5 years) and the value of the factory at the end of quarter 20 is 0 Only Basic jetpacks should be manufactured at the factory throughout its lifetime. There is no investment in research to streamline production or material consumption. Suppose the quarterly demand in the market is constant and given at P = 228 - 0.007 * Q, where P is price and Q is the number of jetpacks in demand. There are 5 competitors in the market (including you), and all sell the same number of jetpacks each quarter at the price of 193 each. You produce as much as you sell. The costs associated with the quarterly production at the factory are given at K = 158 * Q + 20000, where 158 * Q is direct labor cost and materials, and 20000 is quarterly maintenance cost when Q is the number of jetpacks produced. The company has an annual discount rate of 20% on the investment. This means you need to divide it by 4 to get the quarterly rate. Fill in the calculated NPV before tax in the field. A deviation of 5% from the facets are accepted Recommendation: use Excel or similar tools to perform the calculation for this task. When using the Net Value function in Excel (NPV), pay particular attention to how you handle immediate cash flows. 5.2 Use the calculations you made in Problem 5.1, to calculate the internal rate of return before tax for investment project A described in Problem 5.1. Internal interest rates can be calculated in several ways. Below you will find some options when using Excel. Solve the problem graphically and double check the answer using the built-in function for calculating the internal rate. Graphic Solution: By varying the yield requirement (interest rate) in the calculation for NPV, you can find several sets of values for the interest rate and NPV: (r1, NPV1), (r2, NPV2), (r3, NPV3), etc. Set the values for r and npv in two columns, and plot a line graph based on this data. Read off the internal rate. The method provides an inaccurate solution, but illustrates the evolution of npv (s). Built-in IR function: Excel's built-in function for calculating the internal rate is called IR, and can be used for an accurate calculation of IR. (Note: The investment cost in year 0 is treated here differently than in the NPV function). Fill in the internal interest rate before tax in % in the field below. It is sufficient to answer with one decimal (eg an interest rate of 0.5467231 = 54.7%). A deviation of 5% from the answer is accepted.

Calculate the net present value (NPV) before tax of investment A: a factory. Base your calculation on the following information: The investment cost is paid in full in quarter 0, and the cost of the factory is 100000. The factory has a lifetime of 20 quarters (5 years) and the value of the factory at the end of quarter 20 is 0 Only Basic jetpacks should be manufactured at the factory throughout its lifetime. There is no investment in research to streamline production or material consumption. Suppose the quarterly demand in the market is constant and given at P = 228 - 0.007 * Q, where P is price and Q is the number of jetpacks in demand. There are 5 competitors in the market (including you), and all sell the same number of jetpacks each quarter at the price of 193 each. You produce as much as you sell. The costs associated with the quarterly production at the factory are given at K = 158 * Q + 20000, where 158 * Q is direct labor cost and materials, and 20000 is quarterly maintenance cost when Q is the number of jetpacks produced. The company has an annual discount rate of 20% on the investment. This means you need to divide it by 4 to get the quarterly rate. Fill in the calculated NPV before tax in the field. A deviation of 5% from the facets are accepted Recommendation: use Excel or similar tools to perform the calculation for this task. When using the Net Value function in Excel (NPV), pay particular attention to how you handle immediate cash flows. 5.2 Use the calculations you made in Problem 5.1, to calculate the internal rate of return before tax for investment project A described in Problem 5.1. Internal interest rates can be calculated in several ways. Below you will find some options when using Excel. Solve the problem graphically and double check the answer using the built-in function for calculating the internal rate. Graphic Solution: By varying the yield requirement (interest rate) in the calculation for NPV, you can find several sets of values for the interest rate and NPV: (r1, NPV1), (r2, NPV2), (r3, NPV3), etc. Set the values for r and npv in two columns, and plot a line graph based on this data. Read off the internal rate. The method provides an inaccurate solution, but illustrates the evolution of npv (s). Built-in IR function: Excel's built-in function for calculating the internal rate is called IR, and can be used for an accurate calculation of IR. (Note: The investment cost in year 0 is treated here differently than in the NPV function). Fill in the internal interest rate before tax in % in the field below. It is sufficient to answer with one decimal (eg an interest rate of 0.5467231 = 54.7%). A deviation of 5% from the answer is accepted.

ENGR.ECONOMIC ANALYSIS

14th Edition

ISBN:9780190931919

Author:NEWNAN

Publisher:NEWNAN

Chapter1: Making Economics Decisions

Section: Chapter Questions

Problem 1QTC

See similar textbooks

Related questions

Question

Calculate the net present value (NPV) before tax of investment A: a factory. Base your calculation on the following information:

The investment cost is paid in full in quarter 0, and the cost of the factory is 100000.
The factory has a lifetime of 20 quarters (5 years) and the value of the factory at the end of quarter 20 is 0
Only Basic jetpacks should be manufactured at the factory throughout its lifetime.
There is no investment in research to streamline production or material consumption.
Suppose the quarterly demand in the market is constant and given at P = 228 - 0.007 * Q, where P is price and Q is the number of jetpacks in demand.
There are 5 competitors in the market (including you), and all sell the same number of jetpacks each quarter at the price of 193 each.
You produce as much as you sell.
The costs associated with the quarterly production at the factory are given at K = 158 * Q + 20000, where 158 * Q is direct labor cost and materials, and 20000 is quarterly maintenance cost when Q is the number of jetpacks produced.
The company has an annual discount rate of 20% on the investment. This means you need to divide it by 4 to get the quarterly rate.

Fill in the calculated NPV before tax in the field. A deviation of 5% from the facets are accepted

Recommendation: use Excel or similar tools to perform the calculation for this task. When using the Net Value function in Excel (NPV), pay particular attention to how you handle immediate cash flows.

5.2 Use the calculations you made in Problem 5.1, to calculate the internal rate of return before tax for investment project A described in Problem 5.1.

Internal interest rates can be calculated in several ways. Below you will find some options when using Excel. Solve the problem graphically and double check the answer using the built-in function for calculating the internal rate.

Graphic Solution:
By varying the yield requirement (interest rate) in the calculation for NPV, you can find several sets of values for the interest rate and NPV: (r1, NPV1), (r2, NPV2), (r3, NPV3), etc. Set the values for r and npv in two columns, and plot a line graph based on this data. Read off the internal rate. The method provides an inaccurate solution, but illustrates the evolution of npv (s).

Built-in IR function:
Excel's built-in function for calculating the internal rate is called IR, and can be used for an accurate calculation of IR. (Note: The investment cost in year 0 is treated here differently than in the NPV function).

Fill in the internal interest rate before tax in % in the field below. It is sufficient to answer with one decimal (eg an interest rate of 0.5467231 = 54.7%). A deviation of 5% from the answer is accepted.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, economics and related others by exploring similar questions and additional content below.