Question
Please read the question first and explain and label each section -Please do not use below ATTACHED answers again. Please explain A. What would be
Please read the question first and explain and label each section -Please do not use below ATTACHED answers again. Please explain
A. What would be Mayfield Real Estate Development's indicated value on the business valuation report.
B. Please explain how to generate an analysis for giving equal weights to the five years of earning data versus giving greater weight to the more recent earning periods (where five is more recent).
C. Given Mayfield Real Estate Development's type of industry, is 5 years of financial information sufficient to provide an accurate picture? Why?
Mayfield Real Estate Development is a company that owns and operates a number of real estate ventures. The company also engages in real estate acquisitions and sales of properties, some of which are properties the company no longer wishes to operate. Similar real estate firms earn a 15-percent rate of return. Mayfield reported the following earnings over the last five years:
Year | Operating Income | Gain (Loss) on Sale of Assets | Net Income |
---|---|---|---|
1 | $1,000,000 | $700,000 | $1,700,000 |
2 | $1,500,000 | $600,000 | $2,100,000 |
3 | $1,100,000 | $400,000 | $1,500,000 |
4 | $1,600,000 | (200,000) | $1,400,000 |
5 | $1,800,000 | (400,000) | $1,400,000 |
DO not need the below answers, please understand that.
Operating Income 1 1,000,000 2 1,500,000 3 1,100,000 41 1,600,000 5 1,800,000 Value of Business As per Year Year Operating Income 1,000,000 1,500,000 1,100,000 1,600,000 1,800,000 1 2 3 4 5 PVIFA @ 15% Value of Business As per Discounted Cash Flow Method Gain (Loss) on Sale of Assets 700,000 600,000 400,000 (200,000) (400,000) 700,000 600,000 400,000 (200,000) (400,000) Weighted Average Income Value of Business Weighted Average Value of Business Income * PVIFA $ 5,548,938.89 Value of Business As per Discounted Weighted Average Method Gain (Loss) on Sale of Assets Net Income 3.3522 1,700,000 2,100,000 1,500,000 1,400,000 1,400,000 Net Income 1,700,000 2,100,000 1,500,000 1,400,000 1,400,000 Weighted Income Weights 1533333*3.3522 PVIF @ 15% 0.8696 0.7561 0.6575 0.5718 0.4972 $ 5,139,971.15 Weights 1 2 3 4 5 15 $ 23,000,000.00 15 $ 1,533,333.33 Discounted Cash Flow $ 1,478,260.87 $ 1,587,901.70 $ 986,274.35 $ 800,454.54 $ 696,047.43 Weighted Income $ 1,700,000.00 $ 4,200,000.00 $4,500,000.00 $ 5,600,000.00 $7,000,000.00 $ 23,000,000 Mayfield Real Estate Development is in the field of building residential apartments. Yes, it is sufficient if years data is available. Here they are using past data analysis for the valuation using the past trends that's is based on historical earnings. If we are able to value the same using future projected cash flows its more reasonable. Here it is mentioned the case of Mayfield Real Estate Development is a company that owns and operates a number of real estate ventures. The company also engages in real estate acquisitions and sales of properties, Mayfield reported the following earnings over the last five years: Year 1 2 3 4 5 Operating Income Gain(Loss) on Sale of Assets Net Income $1,000,000 $1,500,000 $1,100,000 $1,600,000 $1,800,000 ANSWER $700,000 $600,000 $400,000 (200,000) (400,000) $1,700,000 $2,100,000 $1,500,000 $1,400,000 $1,400,000 From the above table shows that, Mayfield Real Estate Development a lower rate of Net income in the 4th and 5 th year with regards the previous year's Net income. This happened with the loss on sale of assets in 4th and 5th Year. Year 1 shows a remarkable gain on sale of Assets i.e., $700,000 and that year the operating income shows $1,000,000 and net income showed $1,700,000. Higher gain in these five year companies operation, that was showed $700,000 in 1st year. Here the Rate of Return of the similar estate firms are mentioned in this is 15%. From this table clearly showed about the major loss happened in the operation of the company that was 5th year and the amounted of $ 400,000. In the five year operation of the company 3 year brought gain on sale of assets respectively, $700,000,$600,000 and $400,000 total of $1,700,000. But the company make a loss on sale of assets respectively 4th and 5th years amounted $200,000 and $ 400,000 total of $ 600,000. The company showed higher net income in 2nd year period, the amount of $2,100,000 and lower net income in two consecutive years i.e., 4th and 5th year amounted of $1,400,000 respectively. With this five years data it provide a clear picture about the companies present condition is good or bad. From this table we can understand that the comapanies net income as a diminishing level with regards to the previous years. But more income spend for the operating purpose. Operating expenses of the company are more than based on the previous years. Year 4 and 5 shows a high operating income but a minus value in the sale of Assets. It make a diminshing margin in the Net income of Mayfield Real Estate Development. Operating Income 1 1,000,000 2 1,500,000 3 1,100,000 41 1,600,000 5 1,800,000 Value of Business As per Year Year Operating Income 1,000,000 1,500,000 1,100,000 1,600,000 1,800,000 1 2 3 4 5 PVIFA @ 15% Value of Business As per Discounted Cash Flow Method Gain (Loss) on Sale of Assets 700,000 600,000 400,000 (200,000) (400,000) 700,000 600,000 400,000 (200,000) (400,000) Weighted Average Income Value of Business Weighted Average Value of Business Income * PVIFA $ 5,548,938.89 Value of Business As per Discounted Weighted Average Method Gain (Loss) on Sale of Assets Net Income 3.3522 1,700,000 2,100,000 1,500,000 1,400,000 1,400,000 Net Income 1,700,000 2,100,000 1,500,000 1,400,000 1,400,000 Weighted Income Weights 1533333*3.3522 PVIF @ 15% 0.8696 0.7561 0.6575 0.5718 0.4972 $ 5,139,971.15 Weights 1 2 3 4 5 15 $ 23,000,000.00 15 $ 1,533,333.33 Discounted Cash Flow $ 1,478,260.87 $ 1,587,901.70 $ 986,274.35 $ 800,454.54 $ 696,047.43 Weighted Income $ 1,700,000.00 $ 4,200,000.00 $4,500,000.00 $ 5,600,000.00 $7,000,000.00 $ 23,000,000 Mayfield Real Estate Development is in the field of building residential apartments. Yes, it is sufficient if years data is available. Here they are using past data analysis for the valuation using the past trends that's is based on historical earnings. If we are able to value the same using future projected cash flows its more reasonable. Here it is mentioned the case of Mayfield Real Estate Development is a company that owns and operates a number of real estate ventures. The company also engages in real estate acquisitions and sales of properties, Mayfield reported the following earnings over the last five years: Year 1 2 3 4 5 Operating Income Gain(Loss) on Sale of Assets Net Income $1,000,000 $1,500,000 $1,100,000 $1,600,000 $1,800,000 ANSWER $700,000 $600,000 $400,000 (200,000) (400,000) $1,700,000 $2,100,000 $1,500,000 $1,400,000 $1,400,000 From the above table shows that, Mayfield Real Estate Development a lower rate of Net income in the 4th and 5 th year with regards the previous year's Net income. This happened with the loss on sale of assets in 4th and 5th Year. Year 1 shows a remarkable gain on sale of Assets i.e., $700,000 and that year the operating income shows $1,000,000 and net income showed $1,700,000. Higher gain in these five year companies operation, that was showed $700,000 in 1st year. Here the Rate of Return of the similar estate firms are mentioned in this is 15%. From this table clearly showed about the major loss happened in the operation of the company that was 5th year and the amounted of $ 400,000. In the five year operation of the company 3 year brought gain on sale of assets respectively, $700,000,$600,000 and $400,000 total of $1,700,000. But the company make a loss on sale of assets respectively 4th and 5th years amounted $200,000 and $ 400,000 total of $ 600,000. The company showed higher net income in 2nd year period, the amount of $2,100,000 and lower net income in two consecutive years i.e., 4th and 5th year amounted of $1,400,000 respectively. With this five years data it provide a clear picture about the companies present condition is good or bad. From this table we can understand that the comapanies net income as a diminishing level with regards to the previous years. But more income spend for the operating purpose. Operating expenses of the company are more than based on the previous years. Year 4 and 5 shows a high operating income but a minus value in the sale of Assets. It make a diminshing margin in the Net income of Mayfield Real Estate Development
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started