Finance 3.0 - Social Network for Finance
Smart financial thinking
-
Joseph
- Property Investment Analyst
- Share
- Share on Twitter
- Share on Facebook
- Blog Posts (1)
- Discussions (17)
- Events
- Groups (1)
- Charts
- Chart Portfolios
- Videos
- Joseph's Apps (1)
Joseph's Discussions
Joseph's Page
Gifts Received
Joseph has not received any gifts yet
Latest Activity
Please find Matt H evans Financial Forecast Model, it's really easy to understand .
Rgrds
Hi all, In simple terms I would start with balancing the 'expanded' accounting equation:
(cash + operating assets) = liabilities + contributed capital + beginning retained earnings + revenue - expenses - dividends.
So the key high level items for t…
Dear Michel,
Please upload the model so that we can access it. You have forgotten to upload it in your earlier post.
Kind regards
Hi there,
You don't need to use a macro to create that really cool functionality on excel. Your spreadsheet is using a scroll bar (but you can using a spinner). I am currently at home (with a Mac) therefore I cannot recall exactly how to get this o…
Hi Malesh,
I have been following the debate over the last couple of days, and you may by now be a bit confused. The issue is whether you want to analyse at project level or at company level. Many responses to your original query related to project…
Hi Guys,
Here is my template.
Joseph
Hi Mahesh,
I think that critical ratios within a real estate development context, among others, are are as follows:
- EBIT margin;
- NPAT margin;
- Gross margin;
- ROA;
- Net Interest Cover;
- Days Debtors/Creditors;
- Inventory Turnover Ratio;
-…
I too do not see the model, where can I find it?
Profile Information
- Profession:
- Property
- Current Role:
- Property Investment Analyst
- Past Experience:
- Corporate/Commercial Property Lawyer
- Current Location:
- Melbourne
- Interested In:
- knowledge and training
Joseph's Blog
S curve distribution - Project Finance
Dear all,
I am currently working on complex financial property model.
I would like to know if anyone know how to create an S curve distribution on excel for a specific period of time (e.g construction period). Currently, my model has an if statement (which I can control from my assumptions page)which says something like:
"=IF(OR('Stage-Floor 1'!G25<=Construction_period_1,'Stage-Floor 1'!G25>Construction_end1),0,(Raw_Land_Value_per_Lot*Lots_per_stage_1)/Total_const_period_1).
In my cash… Continue
I am currently working on complex financial property model.
I would like to know if anyone know how to create an S curve distribution on excel for a specific period of time (e.g construction period). Currently, my model has an if statement (which I can control from my assumptions page)which says something like:
"=IF(OR('Stage-Floor 1'!G25<=Construction_period_1,'Stage-Floor 1'!G25>Construction_end1),0,(Raw_Land_Value_per_Lot*Lots_per_stage_1)/Total_const_period_1).
In my cash… Continue
Posted on December 16, 2008 at 6:51pm — 9 Comments
Comment Wall (6 comments)
- At 11:17am on October 3, 2008,
Steve Sample said… - Thanks Joseph,
The model I currently creating is somewhat of a blend of the two you attached. The setup is much like the one using NPV, but the reasoning is based on IRR like in your first run at it.
My model is just a little bit different in that the investor gets 100% of their equity investment back before any splits begin. I may post it for you to take a look at when I am done to see if you detect any inaccuracies in my reasoning.
Thanks for your help,
Steve
- At 9:04pm on October 2, 2008,
Joseph said…
- static models.xls
More - again not CF based
- At 9:01pm on October 2, 2008,
Joseph said…
- Hey sorry consider static model for Bert
- At 9:01pm on October 2, 2008,
Joseph said…
- static models -BERT 130807.xlsanother 1
- At 8:59pm on October 2, 2008,
Joseph said…
- static models.xlsHi Steve a couple of basic models attached.
Please note these are not CF based and are only really valid for short project (appr 1 year). It is really a 'back of the envelope" or "quick and dirty" type of analysis to see what you can pay for the land. If it doesn't work this way your CF can only be worst because of capitalised interest on borrowings. Please note the GST on land was creating a circular reference thus it is not exactly 10% be aware of that. In this case you work on a Net Development Value (that is the profit margin is based on what is available for the land).
Cheers.
- At 5:32pm on October 2, 2008,
Steve Sample said…
- Joseph,
I am working on a waterfall CF with parameters very similar to the example in your post. I was wondering if you are still using your last model posted that utilizes the NPV calculation? Have you found or developed any other models that you could share?
Thanks,
Steve
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
