# financial modeling

1. ### Recursion

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 Eg. A0 = A*5 A1 = (A0 - A0*B -C)*5 A2 =( A1 - A1*B-C)*5 etc eg A= 10000 B = 10% C = 100 January = 50000 Feb = 44500 March...
2. ### Sensitivity Analysis

Hey everyone, I have two difficulties to finalize my Sensitivity Analysis and hope that someone can help me out. This is my simplified basis table: <tbody> Income Statement Forecast NET SALES 4907,7 Number of Stores 368 Net Sales per Store 13,3 Cost...
3. ### Issues getting a vba function to call another vba function

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...
4. ### Excel Consistent Formula Needed Across 24 Months

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...
5. ### Register: ModelOff APAC Meetups 2015 (AUS, IND, HK, SG)

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...
6. ### Formula for Sales Milestone Payments

Hi All, 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...
7. ### Finals in New York this Sunday

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...
8. ### ModelOff 2014 - starts 25th October!

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...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back