Business Valuations made easy for Unlisted Business. Automated Cash Flow, NPV, IRR, MIRR with PE Ratio

Description
This Business Valuation Model is suitable for all types of unlisted Businesses. The stark reality is that all funders, analysts, and prudent investors operate on the same basis. They need to know the historical IRR and MIRR and assess whether these returns will exceed the funder's rate (hurdle rate) multiple times. The more the better. Each Industry type will have a different risk profile therefore the PE Ratio applied will differ from business to business. The Model only requires basic input such as basic Assets that are included in the prospective sale, the past 5-year NPAT results, and various mitigating factors such as future prospects and excessive drawings by the previous owner. Once these input fields are complete, the Business Valuation Model will automatically calculate the cash flows without any inflationary growth, and calculate the NPV, IRR, and MIRR over form a 3 to 10-year period. These are the pertinent facts that determine if the business is valued correctly. How often will the IRR and more importantly MIRR exceed the funder's rate? The most important factor anywhere on the globe is that the price must make sense when ungeared (cash sale) and how much gearing will be available due to the profitability. The model has an automated loan amortization built into the model which will help factor in the effects of gearing for a buyer proposition. So, for Sellers, Buyers, Business Brokers, and Funders, this model is compact and gets straight to the point.