Question

In: Economics

Annual net profits at a facility are shown in the table below. Total capital for the...

Annual net profits at a facility are shown in the table below. Total capital for the facility
investment is known to be $ 140 000. Linear as the depreciation method in profitability calculations
depreciation will be accepted. Interest type compound interest and cash flows are separated.
It indicated. In case the minimum acceptable turning speed is 15%,
a) Net return method,
b) Investigate whether the investment is profitable using the net present value method.
Years Net profits, $ / year
1 30 800
2 20 000
3 25 000
4 35 000
5 10 000

Solutions

Expert Solution

The initial investment is $140000 and depreciation method is straight line for the life of 5 years.
We need to calculate NPV here.
PV = Cash Flow / (1+Interest Rate)^Duration

a) Net Return
RoR = (Net Profit / Initial Investment) * 100

Year Cash Flow
0 -140000
1 30800
2 20000
3 25000
4 35000
5 10000
Total -19200


( -19200 / 140000 ) * 100 = -13.71%

b) We will calculate the net cash flow and then discount it by 15%
Depreciation = Asset value - Salvage Value / Life in Years
(140000 - 0) / 5 = 28000

1st year
Profit - Depreciation expense = Net Cash Flow
30800 - 28000 = 2800

2800 / (1.15^1) = 2434.78
We can construct a table for these values

Year Cash Flow Depreciation Net Cash Flow PV @ 15%
0 -140000
1 30800 -28000 2800 2434.78
2 20000 -28000 -8000 -6049.15
3 25000 -28000 -3000 -1972.55
4 35000 -28000 7000 4002.27
5 10000 -28000 -18000 -8949.18
Total -19200 -19200.00 -10533.82


NPV = -10533.82

The NPV is negative so the investment is not profitable.


Related Solutions

Leverage Sensitivity Exercise View table below of baseline profits: Profits from Operations Unchanged Total Debt $...
Leverage Sensitivity Exercise View table below of baseline profits: Profits from Operations Unchanged Total Debt $ 14.00 $ 18.00 $ 22.00 $ 26.00 Total Equity $ 59.00 $ 55.00 $ 51.00 $ 47.00 Profit From Operations $ 14.00 $ 14.00 $ 14.00 $ 14.00 Interest Expense (6% of Debt) $ (1.08) Net Profit Before Taxes $ 12.92 Taxes (38%) $ (4.91) Net Profit After Taxes $   8.01 Debt to Equity Ratio     0.327 Return on Equity 14.56% Based on these...
Using the financial statements shown below, calculate net operating working capital(NOWC)
                                    Chapter Two -- Spreadsheet Assignment     Using the financial statements shown below, calculate net operating working capital(NOWC), total net operating capital (OC), net operating profit after taxes (NOPAT), operating cash flow (OCF), free cash flow (FCF), and return on invested capital (ROIC).                                      ...
PROVIDE EQUATIONS OR FORMULAS a. Using the financial statements shown below, calculate net operating working capital,...
PROVIDE EQUATIONS OR FORMULAS a. Using the financial statements shown below, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for the most recent year. The federal-plus-state tax rate is 25%. Lan & Chen Technologies: Income Statements for Year Ending December 31 (Millions of Dollars) 2020 2019 Sales $945,000 $900,000 Expenses excluding depreciation and amortization 812,700 774,000   EBITDA $132,300 $126,000 Depreciation and amortization 33,100 31,500   EBIT $99,200...
In the following table, the profits from a duopoly model of competition are shown. Firms 1...
In the following table, the profits from a duopoly model of competition are shown. Firms 1 and 2 simultaneously choose the quantity of outputs to produce. Each firm is restricted to producing 25, 35, 50 or 100 units of output. Is there a Nash equilibrium? What is it? Briefly explain. Firm 2 Q2 = 25 35 50 100 Q1 = 25 125, 125 100, 140 63, 125 -63, -250 Firm 1 35 140, 100 105, 105 53, 75 -123, -350...
The annual profits for a company are given in the following table. Write the linear regression...
The annual profits for a company are given in the following table. Write the linear regression equation that represents this set of data, rounding all coefficients to the nearest ten-thousandth. Using this equation, estimate the year in which the profits would reach 413 thousand dollars. Year (x)                Profits (y) (in thousands of dollars) 1999 112 2000 160 2001 160 2002 173 2003 226 Can you please show step by step solution thanks.
The table below gives the annual total returns on Global Balanced Index Fund from 1999 to...
The table below gives the annual total returns on Global Balanced Index Fund from 1999 to 2008. The returns are in the local currency. Use the information in this table to answer the following questions: Table 1: Global Balanced Index Fund Total Returns, 1999-2008 Year Return 1999 50.21% 2000 -2.18% 2001 12.04% 2002 26.87% 2003 49.90% 2004 24.32% 2005 45.20% 2006 -5.53% 2007 -13.75% 2008 -39.06% a. Calculate the mean absolute deviation (MAD). Calculation of MAD for Germany Index Total...
The table below gives the annual total returns on Global Balanced Index Fund from 1999 to...
The table below gives the annual total returns on Global Balanced Index Fund from 1999 to 2008. The returns are in the local currency. Use the information in this table to answer the following questions: Table 1: Global Balanced Index Fund Total Returns, 1999-2008 Year Return 1999 50.21% 2000 -2.18% 2001 12.04% 2002 26.87% 2003 49.90% 2004 24.32% 2005 45.20% 2006 -5.53% 2007 -13.75% 2008 -39.06% (5.0 pts) Calculate the mean absolute deviation (MAD). Calculation of MAD for Germany Index...
The following table of values gives a company's annual profits in millions of dollars. Rescale the...
The following table of values gives a company's annual profits in millions of dollars. Rescale the data so that the year 2005 corresponds to  x=1 . Year 2005 2006 2007 2008 2009 2010 Profits (in millions of dollars) 51.8 63.4 66.3 65.8 62.1 63.8 Use the power regression model to predict the company's profits in 2012. a) $70.2 million b) $68.6 million c) $71.5 million d) $67.7 million e) $66.6 million f) None of the above
Given the data shown in the table for​ a​ monopolist: Output Price Total Cost MC Total...
Given the data shown in the table for​ a​ monopolist: Output Price Total Cost MC Total Revenue Marginal Revenue 1 10 10 2 9 11 3 8 13 4 7 16 5 6 20 6 5 25 1. Complete the​ table​ -- calculate​ ​MC, Total Revenue and MR for all output levels. 2. When the output level is 6​ units​: ​   a. Should the​ monopolist​ increase, decrease or leave​ output​ unchanged? ​  b. Is MR​ greater​ than,​ less​ than, or...
A firm with sales of $1,000,000, net profits after taxes of $30,000, total assets of $1,500,000,...
A firm with sales of $1,000,000, net profits after taxes of $30,000, total assets of $1,500,000, and total liabilities of $750,000 has a return on equity of Seleccione una: A. 3 percent. B. 15 percent. C. 4 percent. D. 20 percent.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT