Charlie's Financial Calculator 34871.58416053241
## Calc Charlie's Financial Calculator 34871.58416053241 Description Code Given Calculated Notes When are payments due Type 0.0 <=== Type (0 Annuity, 1 Annuity Due) Best guess of expected value Guess 0.1 Periods per year NPERY 12.0 <=== Usually: 1 for Bonds Number of Years (to maturity) YEARS 12.0 12.0 <=== Leave year blank to calculate years Number of Periods NPER 144.0 Annuity (Payment, Dividend) PMT -273.57 -273.57 <=== Negative for payments, zero if appropriate Present Value, investment PV 31246.274788270308 <=== Negative for payments, zero if appropriate Future Value, redemption, par value FV 0.0 0.0 <=== Negative for payments, zero if appropriate Nominal Interest Rate Year Nominal_Rate 0.04 0.04 <=== Yearly interest rate Effective Interest Rate Year Effect_rate 0.040741542919790596 <=== Not usually Used Interest Per Period RATE 0.0033333333333333335 Total Payments -39394.08 Total Payments + FV + PV -8147.805211729694 <=== Usually the cost of doing business A given loan payment PER 1.0 Interest portion of period per -104.15424929423436 Principal Portion of period per -169.415750 …
Download the original document · Plain text (TXT) · Browse the archive · How this archive works
Original source: https://web.archive.org/web/19961206224543id_/http://manta.uvi.edu:80/cerit/fincalc.xls
SHA-256 f7cb8a302c626bcbd7d99ce03fafc768d151cc0e1c0ea2fdfee05061e0a7fe87
Re-using this document
Our description, tagging, arrangement, extracted text and machine transcripts are released under CC0 1.0. We assert nothing about the document itself.
Archive identifier LF-f7cb8a302c62
Document text
## Calc Charlie's Financial Calculator 34871.58416053241 Description Code Given Calculated Notes When are payments due Type 0.0 <=== Type (0 Annuity, 1 Annuity Due) Best guess of expected value Guess 0.1 Periods per year NPERY 12.0 <=== Usually: 1 for Bonds Number of Years (to maturity) YEARS 12.0 12.0 <=== Leave year blank to calculate years Number of Periods NPER 144.0 Annuity (Payment, Dividend) PMT -273.57 -273.57 <=== Negative for payments, zero if appropriate Present Value, investment PV 31246.274788270308 <=== Negative for payments, zero if appropriate Future Value, redemption, par value FV 0.0 0.0 <=== Negative for payments, zero if appropriate Nominal Interest Rate Year Nominal_Rate 0.04 0.04 <=== Yearly interest rate Effective Interest Rate Year Effect_rate 0.040741542919790596 <=== Not usually Used Interest Per Period RATE 0.0033333333333333335 Total Payments -39394.08 Total Payments + FV + PV -8147.805211729694 <=== Usually the cost of doing business A given loan payment PER 1.0 Interest portion of period per -104.15424929423436 Principal Portion of period per -169.41575070576562 Note: Cash flows out are negative. Be sure to consider more than one payment a year. Use zeros where necessary! ## PMTS Payment Schedule Using Standard Payment Using Last Payment Principle 31246.274788270308 Total Payments -163.5431355488987 144.00000000000057 Rate 0.04 Remaining Payments 23 Start Date 34700.0 Payoff Date Number Years 12.0 Payment -273.57 Last Payment Date 34700.0 Payoff Date 0 yrs, 0 ms Number Payments 144.0 Future Interest 23 Amt. Last pmt -273.57 Payments Made 23 Payment Due Date/ Date Paid Principle Payment Due Payment Made Interest part Principle Part Ending Principle Interest Paid/Day 1.0 34700.0 31246.274788270308 -273.57 -106.15172804782242 -167.41827195217758 31078.85651631813 -3.424249291865239 2.0 34731.0 31078.85651631813 -273.57 -105.58296460338215 -167.98703539661784 30910.869480921512 -3.4059020839800693 3.0 34759.0 30910.869480921512 -273.57 -94.84979128392355 -178.72020871607646 30732.149272205435 -3.3874925458544127 4.0 34790.0 30732.149272205435 -273.57 -104.40510985625957 -169.16489014374042 30562.984382061695 -3.36790676955676 5.0 34820.0 30562.984382061695 -273.57 -100.48104454376447 -173.0889554562355 30389.89542660546 -3.349368151458816 6.0 34851.0 30389.89542660546 -273.57 -103.24238446298843 -170.32761553701158 30219.56781106845 -3.330399498806078 7.0 34881.0 30219.56781106845 -273.57 -99.35200376241681 -174.21799623758318 30045.349814830864 3.3117334587472276 8.0 34912.0 30045.349814830864 -273.57 -102.071873343535 -171.498126656465 29873.8516881744 3.292641075597903 9.0 34943.0 29873.8516881744 -273.57 -101.48924957078427 -172.08075042921573 29701.770937745183 3.27384676034788 10.0 34973.0 30045.932438603617 -273.57 -98.78114774335435 -174.78885225664564 29871.14358634697 3.2927049247784788 11.0 35004.0 30220.721290860263 -273.57 -102.6676558922376 -170.9023441077624 30049.8189467525 3.3118598674915356 12.0 35034.0 30391.623634968026 -273.57 -99.91766674510035 -173.65233325489964 30217.971301713125 3.3305888915033455 13.0 35065.0 30565.275968222926 -273.57 -103.83819780985323 -169.73180219014677 30395.544166032778 3.349619284188814 14.0 35096.0 30735.007770413074 -273.57 -104.4148209186636 -169.1551790813364 30565.85259133174 3.3682200296343097 15.0 35125.0 30904.16294949441 -273.57 -98.21596992168087 -175.3540300783191 30728.80891941609 3.386757583506237 16.0 35156.0 30728.80891941609 -273.57 -95.482926320433 -178.087073679567 17.0 35186.0 30550.721845736523 -273.57 -94.8893027415011 -178.6806972584989 18.0 35217.0 30372.041148478023 -273.57 -94.29370041730606 -179.27629958269392 19.0 35247.0 30192.76484889533 -273.57 -93.69611275203042 -179.87388724796958 20.0 35278.0 30012.89096164736 -273.57 -93.09653312787049 -180.4734668721295 21.0 35309.0 29832.417494775233 -273.57 -92.49495490496336 -181.07504509503661 22.0 35339.0 29651.342449680196 -273.57 -91.89137142131327 -181.67862857868673 23.0 35370.0 29469.66382110151 -273.57 -91.28577599271759 -182.2842240072824 24.0 35400.0 29287.379597094226 -273.57 -90.6781619126933 -182.8918380873067 25.0 35431.0 29104.48775900692 -273.57 -90.06852245240228 -183.50147754759772 26.0 35462.0 28920.98628145932 -273.57 -89.45685086057695 -184.11314913942306 27.0 35490.0 28736.8731323199 -273.57 -88.84314036344553 -184.72685963655448 28.0 35521.0 28552.146272683345 -273.57 -88.22738416465695 -185.34261583534305 29.0 35551.0 28366.803656848002 -273.57 -87.6095754452058 -185.9604245547942 30.0 35582.0 28180.84323229321 -273.57 -86.98970736335653 -186.58029263664346 31.0 35612.0 27994.262939656564 -273.57 -86.36777305456768 -187.2022269454323 32.0 35643.0 27807.060712711133 -273.57 -85.7437656314162 -187.8262343685838 33.0 35674.0 27619.234478342547 -273.57 -85.1176781835209 -188.4523218164791 34.0 35704.0 27430.782156526067 -273.57 -84.48950377746594 -189.08049622253407 35.0 35735.0 27241.701660303534 -273.57 -83.85923545672414 -189.71076454327584 36.0 35765.0 27051.990895760257 -273.57 -83.22686624157986 -190.34313375842015 37.0 35796.0 26861.647762001838 -273.57 -82.59238912905181 -190.97761087094818 38.0 35827.0 26670.67015113089 -273.57 -81.95579709281529 -191.6142029071847 39.0 35855.0 26479.055948223704 -273.57 -81.31708308312466 -192.25291691687534 40.0 35886.0 26286.80303130683 -273.57 -80.676240026735 -192.893759973265 41.0 35916.0 26093.909271333567 -273.57 -80.03326082682415 -193.53673917317585 42.0 35947.0 25900.372532160392 -273.57 -79.38813836291358 -194.1818616370864 43.0 35977.0 25706.190670523305 -273.57 -78.74086549078991 -194.82913450921006 44.0 36008.0 25511.361536014094 -273.57 -78.09143504242583 -195.47856495757418 45.0 36039.0 25315.88297105652 -273.57 -77.43983982590059 -196.1301601740994 46.0 36069.0 25119.75281088242 -273.57 -76.78607262532026 -196.78392737467973 47.0 36100.0 24922.96888350774 -273.57 -76.13012620073798 -197.43987379926202 48.0 36130.0 24725.529009708476 -273.57 -75.47199328807372 -198.09800671192627 49.0 36161.0 24527.43100299655 -273.57 -74.81166659903396 -198.75833340096602 50.0 36192.0 24328.672669595584 -273.57 -74.14913882103072 -199.4208611789693 51.0 36220.0 24129.251808416615 -273.57 -73.4844026171008 -200.0855973828992 52.0 36251.0 23929.166211033717 -273.57 -72.81745062582442 -200.75254937417557 53.0 36281.0 23728.413661659542 -273.57 -72.14827546124383 -201.42172453875617 54.0 36312.0 23526.991937120787 -273.57 -71.47686971278132 -202.09313028721868 55.0 36342.0 23324.898806833568 -273.57 -70.80322594515722 -202.76677405484276 56.0 36373.0 23122.132032778725 -273.57 -70.12733669830773 -203.44266330169228 57.0 36404.0 22918.689369477033 -273.57 -69.44919448730208 -204.12080551269793 58.0 36434.0 22714.568563964334 -273.57 -68.76879180225976 -204.80120819774024 59.0 36465.0 22509.767355766595 -273.57 -68.08612110826726 -205.48387889173273 60.0 36495.0 22304.28347687486 -273.57 -67.40117484529479 -206.1688251547052 ## XY Comp X-Y Data Graph Info Given X ==> 10.0 Descriptive Stats Comparative Stats X Y Linear Proj. Exp. Proj. Linear 4029.0 -8867.428571428572 X Y Pearson Product Moment Correlation 0.8112780639170817 1.0 1.0 8.0 -4838.4285714285725 8.591816382752516 Linear Eqn. Y = -8867.429 + 4029.000 * X 31422.571428571428 Mean 4.0 7248.571428571428 FTest 1.3331060881923361e-21 2.0 2.0 32.0 -809.4285714285725 36.19622302512615 Exponential 4.21287204156127 2.039420209774145 Median 4.0 600.0 TTest 0.0620918420148174 3.0 3.0 100.0 3219.5714285714275 152.49005599267025 Exp Eqn. Y = 2.039 * 4.213 ^ X 3591611.907747768 Mode 42 42 4.0 4.0 600.0 7248.5714285714275 642.421093507633 Geometric Mean 3.3800151591412964 642.421093507633 5.0 5.0 15000.0 11277.571428571428 2706.4378637475256 Harmonic Mean 2.6997245179063363 41.62655037662117 6.0 6.0 7000.0 15306.571428571428 11401.87640840476 Minimum 1.0 8.0 7.0 7.0 28000.0 19335.571428571428 48034.646342305445 Maximum 7.0 28000.0 8.0 Range 6.0 27992.0 9.0 Mean Absolute Deviation 1.7142857142857142 8143.673469387754 10.0 Standard Deviation 2.160246899469287 10728.300375752953 11.0 Sample Variance 4.666666666666667 115096428.95238096 12.0 Kurtosis -1.2000000000000002 1.612806258038293 13.0 Skewness 0.0 1.5092957517717902 14.0 Sum 28.0 50740.0 15.0 Count 7.0 7.0 16.0 Confidence Level(95.000%) 0.051199437978346606 254.26859764797237 17.0 18.0 19.0 20.0 ## MACRS MACRS MACRS Years 6.0 <== 4,6,8 Use next highest value Tax Rate 0.4 Initial Value 595000.0 Salvage 100000.0 Salvage Year 5.0 Cost of Cap. 0.1 1/2 MACRS n <=Use 1/2 MACRS in Last year? Year Initial Cash Flow MACRS % MACRS $ MACRS Tax Shield Salvage Value After Tax Book Value After Tax Cash Flow Cash Flow PV MACRS Years 4.0 6.0 8.0 0.0 -595000.0 -595000.0 -595000.0 1.0 200000.0 0.2 119000.0 47600.0 120000.0 167600.0 152363.63636363635 1.0 0.3333 0.2 0.1429 2.0 200000.0 0.32 190400.0 76160.0 120000.0 196160.0 162115.70247933883 2.0 0.4445 0.32 0.24489999999999998 3.0 200000.0 0.192 114240.0 45696.0 120000.0 165696.0 124489.8572501878 3.0 0.1481 0.192 0.17489999999999997 4.0 200000.0 0.1152 68544.0 27417.600000000002 120000.0 147417.6 100688.20435762581 4.0 0.0741 0.1152 0.1249 5.0 200000.0 0.1152 68544.0 27417.600000000002 39436.799999999996 34272.0 120000.0 221126.4 137302.09685130793 5.0 0.1152 0.08929999999999999 6.0 0.0 0.0 0.0 0.0 0.0 0.0 6.0 0.0576 0.0892 7.0 0.0 0.0 0.0 0.0 0.0 0.0 7.0 0.08929999999999999 8.0 0.0 0.0 0.0 0.0 0.0 0.0 8.0 0.0446 0.9423999999999999 303000.0 81959.49730209673 NPV 81959.49730209673 IRR 0.15155848557403157 ## C. Flow Cash Flow Guess 0.1 Finance Rate 0.06 36 <== Profiles Cross at cost of capital Re-Investment Rate (IRR) 0.2134834776384694 A B Difference (1 -2) Internal Rate of Return (IRR) 0.2134834776384694 0.059999999999999915 0.15348347763846948 NPV 649423.6054969942 -2.3283064365386963e-10 649423.6054969945 Payback Period 6.224792483040492 9.433962264150944 -3.209169781110452 Sum of Cash Flows 1749320.0 1280000.0 469320.0 PV of Cash Flows 1145423.605496994 799999.9999999997 345423.60549699434 Cost -496000.0 -800000.0 304000.0 PI 2.309321785276198 0.9999999999999997 1.3093217852761985 MIRR 0.1525354980457656 0.06000000000000005 0.09253549804576555 Life 10.0 10.0 0.0 Salvage 800000.0 800000.0 0.0 Equivelent Annual Annuities (EAA) 148930.22587530356 60694.366576306944 88235.85929899661 Infinite Horizon NPV 2482170.4312550593 1011572.7762717825 1470597.654983277 Worksheet A B Year Expected Net Cash Flows Difference Value Sum Prds PV Value Sum Prds PV 0.0 -496000.0 -800000.0 304000.0 1.0 94932.0 48000.0 46932.0 -401068.0 1.0 89558.49056603773 -752000.0 1.0 45283.018867924526 2.0 94932.0 48000.0 46932.0 -306136.0 1.0 84489.14204343181 -704000.0 1.0 42719.82912068351 3.0 94932.0 48000.0 46932.0 -211204.0 1.0 79706.73777682245 -656000.0 1.0 40301.72558555048 4.0 94932.0 48000.0 46932.0 -116272.0 1.0 75195.03563851175 -608000.0 1.0 38020.495835424976 5.0 94932.0 48000.0 46932.0 -21340.0 2.224792483040492 70938.71286652051 -560000.0 1.0 35868.39229757073 6.0 94932.0 48000.0 46932.0 73592.0 0.0 66923.31402501935 -512000.0 1.0 33838.10594110446 7.0 94932.0 48000.0 46932.0 168524.0 0.0 63135.201910395605 -464000.0 1.0 31922.741453872128 8.0 94932.0 48000.0 46932.0 263456.0 0.0 59561.51123622227 -416000.0 1.0 30115.793824407672 9.0 94932.0 48000.0 46932.0 358388.0 0.0 56190.10493983233 -368000.0 1.0 28411.1262494412 10.0 894932.0 848000.0 46932.0 1253320.0 0.0 499725.35449420026 480000.0 0.4339622641509434 473518.77082402 11.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 12.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 13.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 14.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 15.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 16.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 17.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 18.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 19.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 20.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 21.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 22.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 23.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 24.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 25.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 26.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 27.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 28.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 29.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 30.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 31.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 32.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 33.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 34.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 35.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 36.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 37.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 38.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 39.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 40.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 41.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 42.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 43.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 44.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 45.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 46.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 47.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 48.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 49.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 50.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 51.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 52.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 53.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 54.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 55.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 56.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 57.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 58.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 59.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 60.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 61.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 62.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 63.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 64.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 65.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 66.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 67.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 68.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 69.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 70.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 71.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 72.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 73.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 74.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 75.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 76.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 77.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 78.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 79.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 80.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 81.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 82.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 83.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 84.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 85.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 86.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 87.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 88.0 0.0 1253320.0 0.0 0.0 480000.0 0.0 0.0 ## Inventory Inventory Management Traditional Ordering/Receive Cost 1250.0 1250.0 Setup Costs 0.0 P Cost to place a order 1250.0 C Carrying Costs Unit/year 8.0 8.0 Stockout Costs 0.0 D Known Yearly Demand 1200000.0 1200000.0 EOC Economic Order Quanity 19364.916731037083 Q Units per order 30000.0 30000.0 Cost per Unit 38.0 38.0 Yearly Ordering Costs 50000.0 Yearly Carrying Costs 120000.0 TC Total Yearly Costs 170000.0 Purchase Cost 45600000.0 Total Cost 45770000.0 Average Usage 3287.671232876712 Lead Time 14.0 14.0 Simple Reorder Point 46027.39726027397 Maximimum Usage 0.0 Safety Stock 25000.0 25000.0 Safety Reorder Point 71027.39726027397 ## Cost Standard Cost Sheet Standard Price Standard Usage Standard Cost Actual Price Actual Usage Actaul Cost Price Variance Usage Varaince Budget Variance Direct Materials: A 14.0 4.0 56.0 14.885057471264368 4.35 64.75 0.8850574712643677 0.34999999999999964 -8.75 B 0.0 0.0 0.0 0.0 0.0 C 0.0 0.0 0.0 0.0 0.0 D 0.0 0.0 0.0 0.0 0.0 E 0.0 0.0 0.0 0.0 0.0 Total Direct Materials 56.0 64.75 -8.75 Direct labor: Inspection 36.0 1.5 54.0 37.0 1.55 57.35 1.0 0.050000000000000044 -3.3500000000000014 Operation A 0.0 0.0 0.0 0.0 0.0 Operation B 0.0 0.0 0.0 0.0 0.0 Operation C 0.0 0.0 0.0 0.0 0.0 Total Direct Labor 54.0 57.35 -3.3500000000000014 Overhead: Variable Overhead 20.0 1.5 30.0 21.7 1.5 32.55 1.6999999999999993 0.0 -2.549999999999997 Fixed Overhead 16.0 1.5 24.0 17.566666666666666 1.5 26.35 1.5666666666666664 0.0 -2.3500000000000014 Total Overhead 54.0 58.9 -4.899999999999999 Total Standard Cost 164.0 181.0 -17.0 Units Produced 40000.0 ## Costing Costing Material/Labor Unit Cost AQ Actual Unit Quantity 750000.0 750000.0 AP Actual Unit Price 0.0069 0.0069 SQ Standard (Budget) Quantity 873000.0 873000.0 SP Standard (Budget) Price 0.006 0.006 Price Variance per Unit 0.0008999999999999998 U Usage Varaince -123000.0 F Actual Quantity X Actual Price 5175.0 Actual Quantity X Standard Price 4500.0 Standard Quantity X Standard Price 5238.0 U LRV (Price/Rate Variance) 674.9999999999998 U LEV (Usage/Labor Variance) -738.0 F Total Variance -63.00000000000023 F ## Ratios Ratios 1989.0 Common Size 1988.0 Common Size Assets (Current) 6414.0 0.19674243121376644 4712.0 0.1825648973266176 Assets (Fixed) 4712.0 0.14453544369804608 3430.0 0.13289422704378148 Assets (Total) 11126.0 0.3412778749118125 8142.0 0.3154591243703991 Debt (Total) 4730.0 0.14508757400079753 3020.0 0.11700891127469973 Interest Charges 167.0 0.005122542253305114 133.0 0.00515304145679969 Inventory 42 42 42 42 Liabilities (Current) 3990.0 0.12238888377657127 2845.0 0.11022859356838435 Liabilities (Long Term) 740.0 0.02269869022422625 185.0 0.007167764432390546 Liabilities (Total) 4730.0 0.14508757400079753 3030.0 0.1173963580007749 Profit After Taxes 1291.0 0.039600012269562286 1075.0 0.0416505230530802 Taxes 751.0 0.023036103187018802 631.0 0.02444788841534289 Profit before Taxes 2042.0 0.06263611545658108 1706.0 0.06609841146842309 Receivales 42 42 42 42 Sales 32601.0 1.0 25810.0 1.0 Sales (Daily) 89.31780821917808 70.71232876712328 Liquidity Sample Current 1.6075187969924811 1.656239015817223 2.5 Higher Quick 42 42 1.0 Higher Leverage Debt to Total Assets 0.42513032536401224 0.3709162367968558 0.33 Lower Times interest Earned 13.22754491017964 13.827067669172932 8.0 Higher Activity Inventory Turnover 42 42 9.0 Higher Average Collection Period 42 42 20.0 Lower Fixed Assets Turnover 6.918718166383702 7.524781341107872 5.0 Higher Total Assets Turnover 2.9301635808017257 3.1699828052075656 2.0 Higher Profitability Profit Margin on Sales 0.039600012269562286 0.0416505230530802 0.05 Higher Return on Total Assets 0.11603451375157289 0.13203144190616556 0.1 Higher