Finance 3.0 - Social Network for Finance
Smart financial thinking
-
Brano Ilic
- Male
- Darwin, NT
- Australia
- Senior Analyst
- Share
- Share on Twitter
- Share on Facebook
- Blog Posts
- Discussions (41)
- Events
- Groups
- Charts
- Chart Portfolios
- Videos
Brano Ilic's Discussions
CAGR Formula
Replied Jun 11
Brano Ilic's Page
Gifts Received
Brano Ilic has not received any gifts yet
Latest Activity
hi all, I just want to add that CAGR is great for working out uniform year-on-year historical changes, but be careful on relying on this number to forecast the future. The CAGR growth rate is actually biased on the starting and ending values; and fo…
Hi Jitendra, I've modified & re-attached your file.
Brano
Hi, a pivot table will work - but if you want to use a formula to extract unique entries, try the following: (add the formula in the next column & drag down).
=IF(COUNTIF($A$1:A1,A1)=1,A1,"")
This assumes your list starts in A1.
Brano
Hey Nicole, as per Toby's response - the IRR is the discount rate which yields an NPV of zero. If you compare this to your hurdle rate (i.e., the required return or wacc) you can make a recommendation on the project. So if the IRR is higher than WAC…
So the total paid for the room is $25, but in addition the guests effectively paid a $2 gratuity to the bellboy. The remaining $3 was given as change.
Yes I don't see now that there is a problem :-)
Nice try..
But the 3 men each paid $9 less $2 kept by the bellboy divide by 3 of course); which equals $9 - ($2/3). The total being paid of $25.
Hi all, here's an interesting view on valuing a proposition.. I'm sure you'll all appreciate :-)
No problems ... its the same in Darwin, prices are out of this world (so to speak :-)..
My advice would be to go 'interest only' on your loan (I think banks generally limit this to 5 years) but it gives you more control over your finances and you c…
Hey Kavita, I see your working in Australia too .. :-)
I've attached an example of the cash flow analysis for property investment. Its fairly self explainatory.
You can biuld a model on a monthly basis, and project interest payments if you'd like t…
Hi all, here's an interesting view on valuing a proposition.. I'm sure you'll all appreciate :-)
I agree, - I guess the equity market values can be viewed as an ex-ante measure (i.e., based on anticipated changes); whereas the growth in the real economy as an ex-post measure (i.e., based on past performance).
Hi fellas, another way you could do this, especially if you are reporting on a regular basis - Is to set up your financial statements in Excel (and format as desired) and then copy and paste special into a Word document. In the paste special dialog…
I've also attached a simple example to work out the wacc using CCA. Note I did not worry about ungearing and then regearing the betas in this instance.
HTHs
Brano
hi, you could base the wacc by undertaking comparable company analysis. I've attached a file discussing the issues with beta estimation.
As per my opinion, i prefer $ 10 Mil NPV in capital investment.
The reason is due to inflation rate the total value of $ 10 mil Cash now will be less than $ 10 Mil NPV.
Day by Day unless the cost inflation rate is added, the real value of $ 10 Mil…
Profile Information
- Profession:
- Finance
- Current Role:
- Senior Analyst
- Education:
- Masters of Applied Finance & Investment
- Current Location:
- Darwin
- Interested In:
- career opportunities, consulting offers, knowledge and training, job enquires, expertise requests, reference requests, getting back in touch
- My LinkedIn
Comment Wall (1 comment)
- At 12:42pm on December 26, 2009,
Timo said…
- Hey, don't know me. I just saw you were also interest in the files. Unfortunatelty I couldn't find them :-(.
Sign in
Badge
Continuing Education
 |
Accounting |
 |
Banking Regulations |
 |
Certification Training |
 |
Commercial Bank Management |
 |
Corporate Finance & Valuation |
 |
Treasury Management |
 |
Credit Risk Management |
 |
Financial Derivatives |
 |
Financial Institution Management |
 |
Financial Markets |
 |
Financial Modeling |
 |
Financial Planning |
 |
Market Risk Management |
 |
Operational Risk Management |
 |
Operations & Compliance |
 |
Quantitative Analysis |
 |
Strategic Financial Management |
Newsletter
Linkedin
RSS
Facebook
Widgets
Twitter© 2010 Created by Finance 3.0.
