Question

In: Accounting

Assume you have developed a business over the past 20 years. You want to determine its...

Assume you have developed a business over the past 20 years. You want to determine its worth if you sell it. The value of the property is $2 million and is paid off (no debt). Over the next 10 years, you expect to sell $200,000 worth of widgets per year, increasing at $20,000 worth of widgets each year.   Your costs are $120,000 per year, increasing at $10,000 per year. However, at year 5 you must spend $2,000,000 to upgrade equipment to keep up with production. Your costs thereafter are $150,000 per year. What is the present value of the business (i.e. total cost if sole today) assuming an interest rate of 4%/year).

Solutions

Expert Solution

1.04
Year Cash Out Flow Sales Operating Cost Net Inflow PVF @4% Present Value
0    2,000,000.00                             -                               -       (2,000,000.00)         1.000         (2,000,000.000)
1           200,000.00           120,000.00              80,000.00 0.9615                 76,923.077
2           220,000.00           130,000.00              90,000.00 0.9246                 83,210.059
3           240,000.00           140,000.00           100,000.00 0.8890                 88,899.636
4           260,000.00           150,000.00           110,000.00 0.8548                 94,028.461
5    2,000,000.00           280,000.00           160,000.00     (1,880,000.00) 0.8219         (1,545,222.961)
6           300,000.00           150,000.00           150,000.00 0.7903               118,547.179
7           320,000.00           160,000.00           160,000.00 0.7599               121,586.850
8           340,000.00           170,000.00           170,000.00 0.7307               124,217.335
9           360,000.00           180,000.00           180,000.00 0.7026               126,465.612
10           380,000.00           190,000.00           190,000.00 0.6756               128,357.192
        (2,582,987.559)

Present Value of Business is negative $2,582,987. Cash inflows are not sufficient to cover the Capital Investments of business.

Note 1: Even after 5th year, cost has been increased $10,000 each year.

Note 2: Opening Value of property has been considered for calculation of NPV.


Related Solutions

Assume that you have an existing small business and you want to improve its financial performance.Relevant...
Assume that you have an existing small business and you want to improve its financial performance.Relevant financial information is defined as “the predicted future costs and revenues that will differ among the alternatives”. What financial information do you believe is most relevant to analyze and understand? Why?
Over the past 20 years the 12 members of the Organisation of Petroleum Exporting Countries have...
Over the past 20 years the 12 members of the Organisation of Petroleum Exporting Countries have made repeated attempts to restrict output in order to maintain high crude oil prices. Between 1990 and 1995, however, crude oil prices dropped by about 20%, due in part to increased production from the former Soviet Union, Latin America, Asia and the North Sea. In light of these increases in oil production from non-OPEC countries, what must OPEC do to maintain the price of...
Over the past 20 years, private equity firms and hedge funds have bought over 80 major...
Over the past 20 years, private equity firms and hedge funds have bought over 80 major retailers in the US and Canada. The chains they own employ more than 1 million of the 15.8 million U.S. retail workers. At the same time, a large share of these private-equity-owned retailers went bankrupt, and they account for about 70% of store closings in 2019. Why have private equity firms bought so many retailers? Why private-equity owned retailers are more likely to file...
You have decide to retire in 20 years and you want to have $2,000,000 e in...
You have decide to retire in 20 years and you want to have $2,000,000 e in the bank when you retire. You currently have $50,000 k. in the bank. The bank pays 4.00% interest compounded yearly. How much money do you need to deposit in your bank account each year in order to meet your retirement goal?
20. You have developed your own questionnaire to assess emotional intelligence in adults. You want to...
20. You have developed your own questionnaire to assess emotional intelligence in adults. You want to compare a group of professors to a group of undergraduate students. You randomly select 5 professors and 5 students to answer the questions on your questionnaire. You want to determine whether the two groups are different on emotional intelligence. Below are the data you collected, with higher scores showing more emotional intelligence on your questionnaire.                         Professors____Students___ 4                      19 16                    10 12                    15...
Assume the that over the past couple of years your investment into a stock that pays...
Assume the that over the past couple of years your investment into a stock that pays no dividends was as follows: Year Starting price Shares bought/sold 2010 49.8 50 bought 2011 55.7 100 bought 2012 50.7 150 sold What is your dollar-weighted annual return for over this period for this investment? Enter answer in percents, to two decimal places. Bonus exploratory question: how does this compare to the average annual return, or the geometric average annual return?
Assume you have operated your business for 20 years.  Sales for the most recent fiscal year were...
Assume you have operated your business for 20 years.  Sales for the most recent fiscal year were $15,000,000.  Net income for the most recent fiscal year was $2,000,000.  Your book value is $12,500,000.  A similar company recently sold for the following statistics: Multiple of Sales:                               1.2x Multiple of Net Income:                     8x Multiple of Book Value:                     0.7x What is an appropriate range of value for your company? b. If you know that your company has future investment opportunities that are far more profitable than the company above, what...
Think of someone you have come to know well over the past few month or years....
Think of someone you have come to know well over the past few month or years. Did your initial impressions of this person match your current impressions? If yes, explain why it has same over the period of time and what factors have contributed in order to make this impression constant or unchanged. If not, explain how stereotypes and preconceived judgments and assumptions had influenced your initial impression of that person?
You are 20 years old and you want to retire when you have saves$1 million....
You are 20 years old and you want to retire when you have saves $1 million. You have inherited $250,000 and will not add any other savings to that amount. The money will be conservatively invested at 6% per annum. At what age will you be able to retire a millionaire?
Q4.      You are 20 years old and have completed your BBA and want to pursue...
Q4.      You are 20 years old and have completed your BBA and want to pursue further education but you don’t want to take money from your father. Your plan is to start working and earn enough money so that you can finance your degree on your own and get yourself enrolled in five years’ time. You estimate that the annual cost of doing an MBA 5 years from today will be PKR 400,000 and the program will be two...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT