Log in

View Full Version : Create an Income Statement based on a SCENARIO


Jan0508
Mar 27, 2009, 12:56 PM
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

Curlyben
Mar 27, 2009, 01:13 PM
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 (https://www.askmehelpdesk.com/finance-accounting/announcement-font-color-ff0000-u-b-read-first-expectations-homework-help-board-b-u-font.html)

Jan0508
Mar 27, 2009, 01:15 PM
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