Results 1 to 5 of 5

financial model

Threaded View

cassandra23 financial model 12-23-2008, 08:12 PM
shg Maybe like this: ... 12-23-2008, 08:52 PM
cassandra23 shg, thanks for the prompt... 12-23-2008, 11:03 PM
cassandra23 shg - disregard last post. I... 12-24-2008, 12:13 AM
shg If you're a happy camper,... 12-24-2008, 12:20 AM
  1. #1
    Registered User
    Join Date
    12-23-2008
    Location
    oakville, Canada
    Posts
    7

    financial model

    Hi everyone - I'm stuck trying to write a formula for my financial model. If anyone can take a stab at a solution, it would be much appreciated.

    I'm trying to write a formula that will equally distribute revenue either over the next 1 month, 2 month or 3 month period depending on size of the deal.

    Details:
    Sales will fit in 1 of 3 categories. Less than 25k; between 25k & 100k; greater than 100k.

    - if under $25K, recognize in next month (month N+ 1)
    - $25K-100K, recognize in two equal parts in months N + 1 and N + 2
    - over $100K, recognize in three equal parts over 3 months
    N + 1, N + 2, N + 3 ...

    thanks
    Last edited by cassandra23; 12-24-2008 at 07:28 PM. Reason: i re-posted under a more accurate thread title. "IF" statement formula

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1