Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Accounting (https://www.askmehelpdesk.com/forumdisplay.php?f=19)
-   -   Create an Income Statement based on a SCENARIO (https://www.askmehelpdesk.com/showthread.php?t=334638)

  • Mar 27, 2009, 12:56 PM
    Jan0508
    Create an Income Statement based on a SCENARIO
    Constants
    Entries per Trial 50
    Cost Per Plot $20.00
    Plots per Trial 100
    Number_Reps_Per_Year_Per_Trial 2
    Number of True Candidates 35
    Monsanto Royalty-1st 5000 units $0.75
    Royalty Rate>5000 $0.42
    Registration Cost $850.00

    Inputs
    Number Trials 17
    % with opportunity 2.5%
    Replications per year 5
    Year on the market 5
    Number Checks 15
    Up-Front Fee 5000
    Estimated annual sales $30,000.00

    Calculations
    Cost Per Trial $2,000.00
    Number of Varieties Applied For 14.875
    Number of Varieties per trial 0.875
    Total Cost Per Year $170,000.00
    Total Cost Per Year for Registration $(61,731.25)
    Total Number of Opportunities 14.875
    Total Plots per year 8500
    Variety Registration Cost $(4,150.00)

    Annual
    TOTAL COSTS $108,268.75
    Number of units sold to breakeven 257,783




    PER VARIETY
    Per Variety
    $7,278.57
    17,330
    Estimated annual sales 30,000
    Expected sales per lifecycle of variety 150,000
    Total revenue over lifecycle $63,000.00
    ROI 8.7
  • Mar 27, 2009, 01:13 PM
    Curlyben
    Thank you for taking the time to copy your homework to AMHD.
    Please refer to this announcement: Ask Me Help Desk - Announcements in Forum : Homework Help
  • Mar 27, 2009, 01:15 PM
    Jan0508

    Curly ben - these are inputs and outputs I have created from a trial setup I had...
    I am not an accountant so am unsure about what will go into the INCOME STATEMENT... I am a Business Analyst-- not "pasting my hw" for you to do

  • All times are GMT -7. The time now is 05:38 AM.