BMW M3 Forum (E90 E92)

BMW Garage BMW Meets Register Search Today's Posts Mark Forums Read


Go Back   M3Post - BMW M3 Forum > BIMMERPOST Universal Forums > Off-Topic Discussions Board
 
Post Reply
 
Thread Tools Search this Thread
      07-26-2011, 10:02 AM   #1
phrozen06
NA V8
 
phrozen06's Avatar
 
Drives: 01 330ci, 08 M3 DCT, 08 VW R32
Join Date: Jan 2006
Location: 3927'33"N 7758'04"W W. Virgina, Kansas

Posts: 1,527
iTrader: (1)

How do you project costs over the next 5 years

Is there a financial instrument that does this for you. Like an excel spreadsheet.

I'm doing a feasibility study on a ficticous car company that wants to enter into the ALMS.
__________________
phrozen06 is offline  
0
Reply With Quote
      07-26-2011, 11:36 AM   #2
aut0sh0cker
meh
 
aut0sh0cker's Avatar
 
Drives: E92 335i, 997.2 C4S
Join Date: Jan 2008
Location: 91362

Posts: 1,758
iTrader: (2)

You want to look into a Discount Cash Flow model (DCF) which essentially sums future cash flows discounted against a risk-free rate of return, hence the name. (Cash flows such as revenues from goods sold, cost of goods sold, operating and legal costs, interest on debt, terminal sale of equity stake, etc.) This will give you a "Net Present Value", i.e. the value of all future net cash flows (both positive and negative) today. If this ending amount is positive, then the company is not only feasible, but should be invested in.

This skims the surface, but you could really write volumes on the subject.
aut0sh0cker is offline   United_States
0
Reply With Quote
      07-26-2011, 01:45 PM   #3
phrozen06
NA V8
 
phrozen06's Avatar
 
Drives: 01 330ci, 08 M3 DCT, 08 VW R32
Join Date: Jan 2006
Location: 3927'33"N 7758'04"W W. Virgina, Kansas

Posts: 1,527
iTrader: (1)

thanks for your help
__________________
phrozen06 is offline  
0
Reply With Quote
      07-27-2011, 01:36 PM   #4
doubleIN
atlien
 
doubleIN's Avatar
 
Drives: '11 e90 335i
Join Date: May 2011
Location: atlanta

Posts: 371
iTrader: (0)

Garage List
2011 BMW 335i  [4.25]
Quote:
Originally Posted by phrozen06 View Post
Is there a financial instrument that does this for you. Like an excel spreadsheet.

I'm doing a feasibility study on a ficticous car company that wants to enter into the ALMS.
definitely use a spreadsheet to help you. Think about all of the costs that could be involved and separate them into "one-time" and "recurring" expenses. One-time expenses would be up-front costs such as the cost of the vehicles, computer hardware and software, etc. Recurring expenses would include items such as facilities rent and utilities, personnel salaries and benefits, fuel for the cars, and whatever money you have budgeted for development of the car.

set up your spreadsheet to show these costs over regular time intervals, which could be monthly, quarterly, or annual, etc. your upfront costs will likely all occur in the first year, but you could have one-time costs that you incur later on, say 5 years into your project. Recurring costs will hit with regular time intervals, and may go up or down depending on the expense item. if they go up and down, these are variable expenses - try to determine what is driving that cost. for example, fuel cost probably depends on the number of test drives and races that your team will partake in over the given time period. so if it costs you $100 of fuel every time you put the car on the track you would be multiplying the fuel cost times the number of races

hopefully this gets you started. I build a lot of models like this at work so ping me if you need further help
doubleIN is offline  
0
Reply With Quote
Post Reply

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -5. The time now is 06:26 PM.




m3post
Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
1Addicts.com, BIMMERPOST.com, E90Post.com, F30Post.com, M3Post.com, ZPost.com, 5Post.com, 6Post.com, 7Post.com, XBimmers.com logo and trademark are properties of BIMMERPOST