Financial models for valuation of a company
Not what you're looking for?
I need help. I don't know how to start this or how to build the excel spreadsheet. This assignment requires to build a financial model for valuation of a company. Start with using historical income statements and build a ten year forecast using the information. This probably sounds easier than it is. I would suggest that you start with the unit growth (compounded) and forecast the units first. From there, you have to calculate what you will charge per unit for general revenue and guess what you want to do with Management revenue. From here, you'll need to decide what expenses are fixed and what are variable and how the forecast should be calculated. Remember that in this case that the units are driving the forecast.
Purchase this Solution
Solution Summary
This solution presents a ten year financial forecast for a fictitious business.
Solution Preview
Hi,
Please see attached for a sample forecast and Excel setup to complete a ten year forecast. I have completed the first three years, as well built in some budgeting events in 2013, 2017 and 2019. I have included those impacts in bold red font for the impacted years.
First, I compared year year over year deltas in the historical data.
This provided me with a conservative, but data-based factor for unit volume ...
Purchase this Solution
Free BrainMass Quizzes
Production and cost theory
Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Situational Leadership
This quiz will help you better understand Situational Leadership and its theories.
Transformational Leadership
This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.