financial modeling

Hi, I have income statements from three different companies. My goal is to make a dashboard or snapshot page that shows one of the line items (ie. Revenue) over a specific period which you type in. In the example below, I want a line chart that displays the revenue of Google between the periods...

I have data set consisting information like Salary, Hire Date, Termination Date, Status of employee. We want to distribute that salary in 12 months and also want to factor 3% increment every year from their joining date. Also want to factor in condition that if any employee joins in current...

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

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

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

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

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