Purchase Solution

perpetual grfowth rate

Not what you're looking for?

Ask Custom Question

See the attached Excel sheet and explain how Perpetual Growth of 2% was derived (it is marked in yellow).

Which formula was used to get 2%or can it be an estimate?

Attachments
Purchase this Solution

Solution Summary

The solution provides a computation of Perpetual Growth in NPV analysis by employing the arithmetic mean.

Solution Preview

Discounted Cash Flow
Millions

Year 1 2 3 4 5 6 7 8 9
2002 2003 2004 2005 2006 2007 2008 2009 2010
EBIT 80 134 181 226 274 326 375 410 443
Tax 27 46 62 77 93 111 128 139 151
Earnings After Tax 53 88 119 149 181 215 248 271 292

Depreciation 18 26 36 45 54 65 75 83 90
Capital Expenditures 290 328 345 310 326 342 299 157 132
Change in Net working ...

Purchase this Solution


Free BrainMass Quizzes
Motivation

This tests some key elements of major motivation theories.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

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.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.