Excel for business model analysis

  • Status: Closed
  • Prize: $10
  • Entries Received: 6
  • Winner: engrtan

Contest Brief

I want a spreadsheet that prospective investors can view on google docs or download. Investors buy coins called creation coins (CCs) in a blockchain organisation that basically pays 20% of revenue to creation coin holders automatically and in perpetuity using Ether. I want prospective investors to be able to see what this is worth to them. They will need to be able to edit what they think total revenue will be in year 1, 2, 5, 10, 20, 50 (for example). The model will tell them NPV, also what standard compound interest would have returned to them. It will need to allow them to select number of coins purchased.

Recommended Skills

Employer Feedback

“It was a great please to work with him. He was responsive, patience, and had the staying power to work until the solutions was found. This freelancer will not let you done! Very good indeed.”

Profile image fraserbsquared, United Kingdom.

Top entries from this contest

View More Entries

Public Clarification Board

  • GwiseTiger
    GwiseTiger
    • 1 year ago

    My entry is up, and I have already prepped a sample file with the formulas you need.

    • 1 year ago
    1. GwiseTiger
      GwiseTiger
      • 1 year ago

      There is a screenshot of how the formula works in excel in a second image.

      • 1 year ago
  • GwiseTiger
    GwiseTiger
    • 1 year ago

    If I may ask, how can revenue be a percentage of income? Income in accounting is revenue minus purchases minus operating costs (also known as revenue after expenses), so revenue is always higher than income. You've also not said why the Payment is beginning at 0 - if the payment is based on the income or the revenue, why would it be zero? And if it is increasing by itself (how?) then how is it relevant to the income and revenue? I did data management in a CA firm for a year and a half and I can't figure out how this can be a viable business model - could you clarify?

    • 1 year ago
    1. fraserbsquared
      Contest Holder
      • 1 year ago

      yes, as described. thanks

      • 1 year ago
    2. GwiseTiger
      GwiseTiger
      • 1 year ago

      Working on an excel sheet - don't close the contest yet!

      • 1 year ago
  • fraserbsquared
    Contest Holder
    • 1 year ago

    read the description. it is not linear

    • 1 year ago
  • Ermicho
    Ermicho
    • 1 year ago

    yes the formula can work in excel and graph can be drawn respectively

    • 1 year ago
  • Ermicho
    Ermicho
    • 1 year ago

    If you have checked I did it by assuming payment increases linearly. but I can also do it by assuming quadratic increase

    • 1 year ago
  • Ermicho
    Ermicho
    • 1 year ago

    If you like I can make some upgrades.

    • 1 year ago
    1. fraserbsquared
      Contest Holder
      • 1 year ago

      go for it!

      • 1 year ago

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!