I have some data that i want modeled over the course of the year.
The model depreciates a value by a set percentage and a set number and then multiplies it by a set value
A0 = A*5
A1 = (A0 - A0*B -C)*5
A2 =( A1 - A1*B-C)*5
B = 10%
C = 100
January = 50000
Feb = 44500
I have two difficulties to finalize my Sensitivity Analysis and hope that someone can help me out.
This is my simplified basis table:
Number of Stores
Net Sales per Store
I'm currently a college student in a financial modeling course and we've recently jumped into vba coding. I don't have much experience, so everything is a bit new. We have a question that assigned to us that follows:
A hybrid linked note is an instrument that provides investors fixed income and...
I have 24 months in my SaaS financial model and some costs have to charged on annual basis. I am unable to draw a formula that can be applied across all the rows consistently and only give me costs at the end of the year e.g. in months 12, 24, 36, and so on.
Similarly, I have to apply a rate at...
This May and June, the ModelOff Team is traveling around APAC to hold local networking events - and you are invited to join the celebrations!
Six FREE drinks networking events will be held in Melbourne (May 26), Sydney (May 27), Singapore (June 9), Bangalore (June 10), Hong Kong (June 11) and...
I am trying to write a formula that pays a specific milestone when cumulative sales are greater than a certain number. There are multiple tiers where this applies, but each milestone can only be paid once. Below are the milestone thresholds and amount paid when each is passed. Does...
2014 ModelOff New York Live Finals (FREE)
If you’re in New York City this Sunday, join leaders from the Finance and Excel communities to witness the crowning of a new Financial Modeling World Champion. Who will follow in the footsteps of Alex Gordon and Hilary Smart and claim the $30,000USD...
Welcome to ModelOff 2014 - the 3rd Annual Financial Modeling World Championships. After the success of Alex Gordon (NZ) in 2012 and Hilary Smart (UK) in 2013, we're on the hunt for our newest World Champion! If you are or know someone talented in Excel, spreadsheets, and financial modeling...
s&p capital iq