{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":40,"n_cols":27,"rows_kept":40,"cut":false,"hidden":false,"merged":[[1,1,1,16],[30,2,30,4],[30,6,30,8],[31,2,31,3],[32,2,32,3],[5,1,5,3],[6,1,6,3],[3,7,3,10],[3,11,3,12],[3,1,3,3],[4,1,4,3],[3,4,3,5],[4,4,4,5],[5,4,5,5],[4,7,4,10],[4,11,4,12],[6,19,6,25],[22,1,22,15],[24,12,24,14],[25,12,25,14],[24,5,24,7],[25,5,25,7],[23,1,23,6],[23,8,23,13],[18,1,18,15],[19,1,20,16],[5,7,6,15],[6,4,6,5],[25,2,25,4],[38,10,38,15],[2,1,2,3],[28,12,28,14],[24,9,24,11],[25,9,25,11],[26,9,26,11],[27,9,27,11],[28,9,28,11],[26,12,26,14],[27,12,27,14],[27,5,27,7],[24,2,24,4],[26,2,26,4],[27,2,27,4],[26,5,26,7],[33,2,33,3],[34,10,34,15],[35,10,35,15],[36,10,36,15],[37,10,37,15],[2,5,2,7],[2,8,2,9],[30,10,30,15],[31,10,31,15],[32,10,32,15],[31,6,31,7],[32,6,32,7],[33,6,33,7],[33,10,33,15]]}
[]
[null,"Heifer Purchase Financial Stress Analysis Tool\nEric A. DeVuyst\nHannah Shear\nDerrel Peel\nDepartment of Agricultural Economics\nOklahoma State University\neric.devuyst@okstate.edu\nAugust 2023, Release version 1.0"]
[null,"Head purchased",null,null,100,null,null,null,"Bred"]
[null,"Heifer purchase price $/head",null,null,{"$f":"600*3","v":1800},null,null,"Anticipated mature cow weight lbs.",null,null,null,1375]
[null,"Down payment $/head",null,null,400,null,null,"Heifer retention rate %",null,null,null,0.5]
[null,"Interest rate",null,null,0.09,null,null,"Notes: Cells in light green are user entered. Blue, Red, Green and Yellow are calculated. \nEnable macros to see calculations."]
[null,"Term (years)",null,null,5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Calculation checks"]
[null,"Age","Steer weaning weight Bir et al. lbs","Steer weaning weight lbs","Heifer weaning weight Bir et al. lbs","Heifer weaning weight lbs","Annual feed cost $/head*","Annual other costs $/head","Streer sale price $/cwt","Hiefer sale price $/cwt","% Calf crop","% Cull by cow age","Cull cow price $/head","End of Year Head Remaining (Culled)","TOTAL Operating cash flow less down payment","TOTAL Principal and interest","TOTAL Cash surplus or deficit",null,null,null,"steer","heifer","cull","rev","cost","operating"]
[null,1,"--","--","--","--",600,25,"--","--","--",0,1400,"100 (0)",0,0,0,null,null,"inc downpay",{"$f":"0","v":0},0,{"$f":"L9*M9","v":0},{"$f":"W9","v":0},{"$f":"G9+H9","v":625},{"$f":"X9-Y9-E5","v":-1025},{"$f":"Z9+P9","v":-1025}]
[null,2,449,449,434,434,600,50,250,235,0.82,0.25,{"$f":"900*0.9","v":810},"75 (25)",3088,-35993,-32905,null,null,"no retention",{"$f":"D10*I10/100*0.5*K10","v":460.22499999999997},{"$f":"F10*J10/100*0.5*K10","v":418.15899999999999},202.5,{"$f":"SUM(U10:W10)","v":1080.884},650,{"$f":"X10-Y10","v":430.88400000000001},{"$f":"Z10+P10","v":-35562.116000000002}]
[null,3,466,466,451,451,625,50,243,{"$f":"I11-15","v":228},0.86,0.1,{"$f":"1200*0.9","v":1080},"67 (8)",11115,-35993,-24878,null,null,null,486.92340000000002,{"$f":"F11*J11/100*0.5*K11*(1-$L$5)","v":221.08019999999999},108,{"$f":"SUM(U11:W11)","v":816.00360000000001},675,{"$f":"X11-Y11","v":141.00360000000001},{"$f":"Z11+P11","v":-35851.996400000004}]
[null,4,480,480,465,465,650,50,238,{"$f":"I12-15","v":223},0.87,0.1,{"$f":"1250*0.9","v":1125},"60 (7)",9381,-35993,-26612,null,null,null,496.94400000000002,225.53662500000002,112.5,{"$f":"SUM(U12:W12)","v":834.98062500000003},700,{"$f":"X12-Y12","v":134.98062500000003},{"$f":"Z12+P12","v":-35858.019375000003}]
[null,5,491,491,475,475,675,50,235,220,0.87,0.12,{"$f":"1300*0.9","v":1170},"53 (7)",8442,-35993,-27551,null,null,null,501.92474999999996,227.28749999999999,140.4,869.6122499999999,725,144.6122499999999,-35848.387750000002]
[null,6,497,497,482,482,700,50,230,215,0.87,0.2,{"$f":"1375*0.9","v":1237.5},"42 (11)",12162.5,-35993,-23830.5,null,null,null,497.24849999999998,225.39524999999998,247.5,970.14374999999995,750,220.14374999999995,-35772.856249999997]
[null,7,499,499,484,484,700,50,225,210,0.87,0.3,{"$f":"1375*0.9","v":1237.5},"29 (13)",14385.5,0,14385.5,null,null,null,488.39625000000001,221.06700000000001,371.25,1080.71325,750,330.71325000000002,330.71325000000002]
[null,8,497,497,482,482,700,50,226,211,0.87,0.4,{"$f":"1375*0.9","v":1237.5},"17 (12)",13684,0,13684,null,null,null,488.60070000000002,221.20185000000001,495,1204.8025499999999,750,454.80254999999988,454.80254999999988]
[null,9,492,492,477,477,725,50,228,213,0.87,0.75,{"$f":"1375*0.9","v":1237.5},"4 (13)",14964.5,0,14964.5,null,null,null,487.96559999999999,220.98217499999998,928.125,1637.0727750000001,775,862.07277500000009,862.07277500000009]
[null,10,483,483,468,468,750,50,236,221,0.86,1,{"$f":"1375*0.9","v":1237.5},"0 (4)",4600,0,4600,null,null,null,490.14840000000004,222.37019999999998,1237.5,1950.0185999999999,800,1150.0185999999999,1150.0185999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21282.5]
[null,"Balance Sheet and Ratio Analysis"]
[]
[]
[null,"Enter Information as of BEFORE Heifer Purchase"]
[null,"Assets",null,null,null,null,null,null,"Liabilities and Equity"]
[null,null,"Current Assets",null,null,1325000,null,null,null,"Current Liabilities",null,null,1325000]
[null,null,"Intermediate Assets",null,null,1800000,null,null,null,"Intermediate Liabilities",null,null,2400000]
[null,null,"Long-term Assets",null,null,15125000,null,null,null,"Long-term Liabilities",null,null,10587500]
[null,null,"Total Assets",null,null,4080000,null,null,null,"Total Liabilities",null,null,772000]
[null,null,null,null,null,null,null,null,null,"Owner' Equity",null,null,3308000]
[]
[null,null,"Before Purchase",null,null,null,"After Purcahse",null,null,null,"Beginning current ratio at warning level."]
[null,null,"Current Ratio",null,1,null,"Current Ratio",null,0.97000002861022949,null,"Ending current ratio at warning level."]
[null,null,"Debt-to-Asset",null,0.77999997138977051,null,"Debt-to-Asset",null,0.79000002145767212,null,"Beginning Debt-to-Asset at warning level."]
[null,null,"Debt-to-Equity",null,3.630000114440918,null,"Debt-to-Equity",null,3.6700000762939453,null,"Ending Debt-to-Asset at warning level."]
[null,null,null,null,null,null,null,null,null,null,"Beginning Debt-to-Equity at warning level."]
[null,null,"Ratio benchmarks",null,null,"Red","Yellow","Green",null,null,"Ending Debt-to-Equity at warning level."]
[null,null,"Current Ratio",null,null,"<1.3","1.3-2.0",">2"]
[null,null,"D/A",null,null,">0.6","0.3-0.6","<0.3"]
[null,null,"D/E",null,null,">1.5","0.43-1.5","<0.43"]
[null,null,"https://extension.umn.edu/farm-finance/ratios-and-measurements"]