LM Client IRR and ROI Calculator
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRST
1
Summary Results
2
ROI (1 Year)
131%
3
IRR (5 Year)
128%
4
5
Investment Model
Lightmanufacturing System, Inc.
6
7
Year 1Year 2Year 3Year 4Year 5Notes
8
Investment in Plant, Property, and Equipment (PPE)
9
Enhanced SRM2 System with 30 Mirrors 170,000 Enhanced SRM2 system with 30 mirrors
10
Fabricated Mold No. 1 15,000 Initial Mold
11
Fabricated Mold No. 2 15,000 Room for additional molds if applicable
12
Fabricated Mold No. 3 <Enter>
13
Total Investment in PPE $ 200,000
Calculates investment minus prior depreciation expense
14
15
Annual Software Fee
Not Applicable
$ 5,000 $ 5,000 $ 5,000 $ 5,000
16
17
Amortize
MANDATORY INPUTS
18
Expense
Sales price per unit $ 250 $ 250 250 250 250 Your net price to buyer
19
Number of production days per week 6 6 6 6 6
How many days per week do you plan to operate
20
Number of units/parts to be produced per day 5 5 5 5 5
How many units per day to you expect to produce
21
Pounds of plastic needed per unit/part 50 50 50 50 50 How many pounds of plastic are needed for each unit produced
22
Price of plastic per pound $ 1 1 1 1 1
Estimated or actual price for one pound of plastic
23
Total number of production hours per week 48 48 48 48 48
Number of production labor hours are required per week
24
Average hourly production wage $ 18 18 18 18 18
Average hourly wage of production employees
25
Total number of overhead hours per week 5 5 5 5 5
Number of overhead labor hours required each week
26
Average hourly overhead wage $ 25 25 25 25 25
Average hourly wage of overhead employees
27
Monthly Rent Expense $ 500 500 500 500 500 Monthly rent expense
28
Monthly Utility Expense $ 80 80 80 80 80 Monthly expense for all applicable utilities
29
Annual business insurance (liability, umbrella, etc.) $ 4,000 4,000 4,000 4,000 4,000
Yearly insurance (except worker's comp) expense
30
31
OPTIONAL INPUTS
32
Depreciation (Pick from drop-down) None
Choose your depreciation method, if applicable
33
Interest (for financing investment only)0%
Interest rate on funds used for this investment only
34
Income tax rate0%0%0%0%0%
Enter the income tax rate for your business
35
Business Start-up costs (Choose to amortize or expense)Amortize - Enter business start-up costs. If you would like to expense the
36
entire amount in Year 1, use the drop-down box to change from
37
"Amortize" to "Expense."
38
INVESTMENT COMPUTATIONS (EBITDA, ROI, IRR)
39
Annual Sales
40
Pirce per unit $ 250.00 $ 250.00 $ 250.00 $ 250.00 $ 250.00
41
No. of Units 1,560 1,560 1,560 1,560 1,560
42
Total Annual Sales $ 390,000 $ 390,000 $ 390,000 $ 390,000 $ 390,000
43
44
Annual Production Expenses
45
Production Labor
46
Rate of Pay $ 18.00 $ 18.00 $ 18.00 $ 18.00 $ 18.00
47
No. of Hours 48 48 48 48 48
48
Total Production Labor $ 864 $ 864 $ 864 $ 864 $ 864
49
Plastic
50
Quantity 78,000 78,000 78,000 78,000 78,000
51
Price per pound $ 1.40 $ 1.40 $ 1.40 $ 1.40 $ 1.40
52
Total Cost of Plastic $ 109,200 $ 109,200 $ 109,200 $ 109,200 $ 109,200
53
Total Annual Production Expenses $ 110,064 $ 110,064 $ 110,064 $ 110,064 $ 110,064
54
55
Gross Profit $ 279,936 $ 279,936 $ 279,936 $ 279,936 $ 279,936
56
57
Annual Operational Expenses
58
Software Fee
Not Applicable
5,000 5,000 5,000 5,000
59
Rent 6,000 6,000 6,000 6,000 6,000 Annualized from entry above
60
Utilities 960 960 960 960 960 Annualized from entry above
61
Overhead Labor
62
Rate of Pay $ 25.00 $ 25.00 $ 25.00 $ 25.00 $ 25.00
63
No. of Hours 260 260 260 260 260
64
$ (200,000)Total Overhead Labor $ 6,500 $ 6,500 $ 6,500 $ 6,500 $ 6,500
65
$ 261,578 Payroll Taxes 530 530 530 530 530 Calculates at 7.2% of payroll
66
$ 256,578 General Business Insurance 4,000 4,000 4,000 4,000 4,000
67
$ 256,578 Worker's Comp Insurance 368 368 368 368 368 Calculates at 5% of payroll
68
$ 256,578 Total Annual Operational Expenses $ 18,358 $ 23,358 $ 23,358 $ 23,358 $ 23,358
69
$ 256,578
70
Earnings before Interest, Taxes, Depreciation and Amortization (EBITDA) $ 261,578 $ 256,578 $ 256,578 $ 256,578 $ 256,578
71
72
Other Expenses
73
Interest $- $- $- $- $-
74
Taxes (income) $- $- $- $- $-
75
Depreciation $- $- $- $- $-
76
Amortization $- $- $- $- $-
77
Total Other Expenses $- $- $- $- $-
78
79
Net Income/(Loss) $ 261,578 $ 256,578 $ 256,578 $ 256,578 $ 256,578
80
81
Return on Investment (Intitial Year of Purchase)131%
82
Internal rate of return31%96%117%125%128%
83
None
84
Straight Line - 5yr
85
Straight Line - 7yr
86
Double Declining - 5yr
87
Double Declining - 7yr
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu