i need help plugging in the random list of notes into the excel Balance sheet schedule.

Schedule 1: Machinery and Equipment See "Schedule 1: Machinery' on "Financial Statement & Analysis Help Tabs" file Date Acquired Acquisition Accumulated Total Cost Value Description mm/wy Cost Depreciation Total Market Value 3 4 5 -6 7 58 Total Cost and Market Values, Machinery and Equipment (transfer to BS): Formatting a D E G H End of Year Balance Sheet Schedules For: Whisenant Farms Year Ending: Tas 2014 Personal Residence Accumulated Depreciation Date Acquired Accuisition Cost Cost Rards BS Use Cost Value Mrkt Bass BS Use Mrkt Value Total Cost and Market Values, Personal Residence (transfer to BS) 0 ol Land and Land Improvements Date Acquired WWW Acquisition Cost/Acre Acres Accumulated Depreciation Market value per acre Total Cost Value Total Market Value 2 3 4 36 Total Cost and Market Values, Land & Improvements transfer to BS): 37 Buildings and improvements Date Acquired Acquisition Cost Accumulated Depreciation Total Cost Value Total Market Value 89 90 7 92 93 94 195 Total Cost and Market Values, Buildings & Improvements (transfer to RS) General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + Schedule K: Leased Assets 196 See "Schedule K: Capital Leases" on "Financial Statements & Analysis Help Tabs" file 197 Intermediate Current Liability, Current Liability, Intermediate 198 Description Asset Value Lease Pmt Accrued interest Liability 199 200 201 202 203 Total Leased Assets (transfer to BS): 0 The initial value of a capital lease is the PV of payments to be made including any downpayments or advanced payments. The value is both an 204 asset and a liability with the liability being split between what is due currently and what remains 7 8 ScheduleL: Investment In Cooperatives and Other Non-Current Investments/Assets (Intermediate and Fixed) Intermediate Fixed Cost Basis BS Mrkt Basis BS Cost Basis BS Mrkt Basis BS Investment in Cooperatives Use Cost Value Use Mrkt Value Use Cost Value Use Mrkt Value 19 10 11 12 13 14 Total Investment in Cooperatives (transfer to BS): Other Investments (Stocks, Bonds, Securities, etc.) 15 16 17 :18 19 220 Total Other investments: 221 222 Other Non-Current Assets (titled vehicles, etc.) 223 224 225 226 227 Total Other Intermediate and Fixed Assets: Total Other Investments/Assets (Transfer to 228 Includes investments in cooperatives, unpaid cooperative dividends investment in the motition Liability Schedules 32 33 Schedule M: Accounts Payable, Credit Cards and Debt Service term and non-term/operating loans) Accounts Payable Includes: wages, repairs, supplies and inputs, rent, Dute herred Next Payment Date Balance Due etc.) www m/ww Interest Rate Acerved Interest Due current ab 235 236 237 238 239 240 241 242 243 240 Total Accounts Payable: Next Payment Date Date incurred www Credit Cards Balance Due leurrent 245 interest Rate Acerunt Due 246 Venture One 247 268 249 250 251 252 Total Credit Cards: Total Accounts Payable & Credit Cards (transfer to BS): End of Year Balance Sheet Schedules For: Whilsenant Farms Year Ending: 2014 Total Accounts Payable & Credit Cards (transfer to RS) rece pe wwww Los Car Dund 12 Months Interme Next Payment wwwwww Cure Porn Due frum) Non-Term/Operating Loans Adre 254 Weighted Weighted Operating Term Interest Interest Rate Rate 0.00% 0.OON 0.00% OOON 0.00N O.OON 0.00% 0.OON 0.00% O.OON 256 257 258 260 Totals Non-Term Loans Total Accrued interest-acets payable, crcards, non-term loans-transfer to ) Total Balances Due. Non-Term Loans frankerto) 261 Term Loans other than mortgage loans plans for machinery, umet mybe past pa) received or at port Barcelone Duend 12 Month Nortamente Cum Porto De Weighted Term interest Rate 0.OON 262 AD 0.CON 0.00N 264 255 256 267 258 269 270 271 272 273 274 225 0.COM 0.00% 0.COM 0.00% DOON D.OON OOON OOON 0.OON Total Term Loans other than mortages or land contracts Lab 6 BS STUDENT Home Insert Draw Data Review View Tell me Calibri (Body) General insert o Doloso v El Format Paste E Conditional Format Cell Formatting as Table Styles AB End of Year Balance Sheet Schedules for Whisenant Farms Year Ending 2014 Term Loans Mortgage & Land Contracts Curreau 12 Months flow 270 277 278 279 280 Weighted Term interest Rare 0.00 0.00N O.COM O.COM 0.BOX 282 Total More Loans 283 Total Accrued interest and Balances Due.Term Loans transfer to 254 Total Balances fets payable, credit card, non term/operating and term loan balances 285 Operating Debt Weighted Average interest Rate G.OON 286 Term Debt and Loss Carryover Weighted Average interest Rate Q.COM 287 Weighted Average Interest Rate on All Debt DIV/0 288 289 Schedule N: Accrued Expenses/Liability Schedule : Income Taxes Payable Description Accrued 290 stemployer wholding, etc) Balance Federal income Tax Payable Balance Due 292 294 295 296 297 Total Federal Taxes Payable transfer to Non federal income Taxes Payable Total Acerved Dapenses/bytravfertes Total Non-fed income Transfer te 299 300 301 Schedule P: Other Llabilities (notes, contracts and other) Current Intermediate Other Liabilities - Notes and Contracts Balances Balances Long-Term Balances Total Notes and Contracts: Other Liabilities - Other Total Other Liabilities: Total Other Liabilities (Transfer to BS): 2 Normal No Spacing Heading 1 End of the Year Financial Notes for the Balance Sheet Schedules Below is a random set of notes in no particular order of assets, liabilities and other information. Your job is to: 1 transfer these notes to the balance sheet schedules (spreadsheet) provided 2 Jot down any questions you have about what the items are, what they mean and/or explanations you would like of the balance sheet schedules Note, not all information will be used. Ultimately your goal is to complete a balance sheet for the case farm for the year 2014 Inventory of raised crops intended for sale 22,750 bushels of corn worth $3.69 6,000 bushels of soybeans worth $10.00 263 bushels of wheat valued at $5.00/bu. Inventory of raised livestock intended for sale 10 head of feeder cattle weighing 400 lbs each and current price is $1.60 per lb. Raised feed Inventory 1,600 tons of hay worth $113 per ton Sold $27,518 of livestock to John Smith. He has not paid for it yet. 14 days old. It is due in 30 days. Cash held at United Savings for farm checking and savings accounts: $1,503 Have prepaid expenses to: ABC Coop for anhydrous fertilizer, 30 tons at $500 per ton ABC Coop for seed, 70 bags for $294.28/bag John's Bar Supply for 28% liquid fertilizer, 40 tons at $250/ton Purchases on credit with local suppliers include: Argies Diesel shop: 5700 ABC Coop: 5356 Farm & Fleet: $748 32 acres of established growing hay ground has $220 of direct expenses per acre Rented the chisel plow to the Jones family for $20,000, which has not been paid for yet. The payment from them is due next month States) Focus Normal No Spacing Heading 1 Credit card balances: Venture One for $1,025 208 acres of new growing hay ground has $170 per acre of direct expenses Purchased breeding livestock on hand. These were recently purchased and market values are the same as the purchase price. 1 Beef Bull that cost $1,500 o 9 Beef Cows costing $1,800 each o 1 Bred heifer that cost $1,400 o 4 open heifers that cost $600 each There are several buildings and many improvements, but in total the original cost of buildings and improvements was $1,225,643 with accumulated depreciation of $855,268. Based on recent sales of nearby farms, estimated market value today is $824,350 Inventory of raised breeding livestock, base value per head, and current market value information is below. Head Beginning of Year Base Melt Value/Head Value/Head 150 400 Breeding Stock Dairy Calves Head End of Year Base Mrit Value/Head Value/Head 150 400 10 10 1 800 1,050 1 Dairy Bull 800 1,050 185 1.200 1,780 199 1,200 1,625 62 1.000 1,175 65 1.000 1.175 Dairy Cows Dairy Bred Heifers Dairy Open Heifers 80 700 800 87 700 800 Land 390.5 acres purchased in 2004 for $2.875 per acre. Now worth $3,433 per acre o 50 acres purchased in 2014 for $9,000. Now worth $9,000 per acre ited States) O Focus Machinery and Equipment Tractor 1 purchased in 2012 (remember this is 2014) for $225,000. Depreciation is based on straight-line, zero salvage value and 7 years of useful life. "Blue Book" (market value) today is $180,000. Assume the year of purchase was a full year of deprecation Tractor 2 purchased in 2010 for $140,000. Depreciation based on straight-line, zero salvage value and 7 years useful life. "Blue Book" - $75,000 Skaid loader purchased in 2011 for $24,000. Depreciation: straight-line, S4,000 salvage value and 5 years useful life. Blue Book market value = $15,000 All other machinery and equipment have total purchase cost of $650,000, accumulated depreciation of $475,764 and market value today of $521,325. Loans Non-term and Operating loans Operating line of credit: Ourrent balance of $192,879, accrued interest of $488 and 3.04% interest rate (no information on date received or next payment) Risk line of credit for marketing: 3,04% rate, $37 accrued interest and a balance of $14,549 Term Debt . FPP bide/land improvements: 3.28% interest, S1,702 accrued interest, principal due beyond this year of $531,061 and principal due this year of $91,918 FPP Machinery Note: principal due beyond this year of $113,363, principal payment this year of $45,664, 2.65% interest rate and $145 of accrued interest Mortgage and Land contracts Just made a payment on both loans so interest is paid to date, that is, no accrued interest. REM: 3.25% interest rate, long-term balance of $1,253,809 and payment this year of 567,268 Land Contract: 2.85% interest rate, long-term balance of 535,361, principal payment this year of $4,655 Accrued Expenses/Liabilities Employer withholding due but not paid $211 Other assets Vehicles with cost and market value of $19,500 (intermediate Asset) ed States) O Focus Other assets o Vehicles with cost and market value of $19,500 (Intermediate Asset) Investment in ABC Cooperative is long-term (Fixed Asset): $5,482 The following do not go on a schedule, but instead are inputs directly to the balance sheet in the Owner Equity Section Net income this year was $141,226 and the accumulation of past income (past retained earings is $495,207 The sum of capital originally contributed to start the farm and since then totals $240,518. There was zero new capital contributions this year There was no owner withdrawal for any reason and no capital distributions this year, Schedule 1: Machinery and Equipment See "Schedule 1: Machinery' on "Financial Statement & Analysis Help Tabs" file Date Acquired Acquisition Accumulated Total Cost Value Description mm/wy Cost Depreciation Total Market Value 3 4 5 -6 7 58 Total Cost and Market Values, Machinery and Equipment (transfer to BS): Formatting a D E G H End of Year Balance Sheet Schedules For: Whisenant Farms Year Ending: Tas 2014 Personal Residence Accumulated Depreciation Date Acquired Accuisition Cost Cost Rards BS Use Cost Value Mrkt Bass BS Use Mrkt Value Total Cost and Market Values, Personal Residence (transfer to BS) 0 ol Land and Land Improvements Date Acquired WWW Acquisition Cost/Acre Acres Accumulated Depreciation Market value per acre Total Cost Value Total Market Value 2 3 4 36 Total Cost and Market Values, Land & Improvements transfer to BS): 37 Buildings and improvements Date Acquired Acquisition Cost Accumulated Depreciation Total Cost Value Total Market Value 89 90 7 92 93 94 195 Total Cost and Market Values, Buildings & Improvements (transfer to RS) General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + Schedule K: Leased Assets 196 See "Schedule K: Capital Leases" on "Financial Statements & Analysis Help Tabs" file 197 Intermediate Current Liability, Current Liability, Intermediate 198 Description Asset Value Lease Pmt Accrued interest Liability 199 200 201 202 203 Total Leased Assets (transfer to BS): 0 The initial value of a capital lease is the PV of payments to be made including any downpayments or advanced payments. The value is both an 204 asset and a liability with the liability being split between what is due currently and what remains 7 8 ScheduleL: Investment In Cooperatives and Other Non-Current Investments/Assets (Intermediate and Fixed) Intermediate Fixed Cost Basis BS Mrkt Basis BS Cost Basis BS Mrkt Basis BS Investment in Cooperatives Use Cost Value Use Mrkt Value Use Cost Value Use Mrkt Value 19 10 11 12 13 14 Total Investment in Cooperatives (transfer to BS): Other Investments (Stocks, Bonds, Securities, etc.) 15 16 17 :18 19 220 Total Other investments: 221 222 Other Non-Current Assets (titled vehicles, etc.) 223 224 225 226 227 Total Other Intermediate and Fixed Assets: Total Other Investments/Assets (Transfer to 228 Includes investments in cooperatives, unpaid cooperative dividends investment in the motition Liability Schedules 32 33 Schedule M: Accounts Payable, Credit Cards and Debt Service term and non-term/operating loans) Accounts Payable Includes: wages, repairs, supplies and inputs, rent, Dute herred Next Payment Date Balance Due etc.) www m/ww Interest Rate Acerved Interest Due current ab 235 236 237 238 239 240 241 242 243 240 Total Accounts Payable: Next Payment Date Date incurred www Credit Cards Balance Due leurrent 245 interest Rate Acerunt Due 246 Venture One 247 268 249 250 251 252 Total Credit Cards: Total Accounts Payable & Credit Cards (transfer to BS): End of Year Balance Sheet Schedules For: Whilsenant Farms Year Ending: 2014 Total Accounts Payable & Credit Cards (transfer to RS) rece pe wwww Los Car Dund 12 Months Interme Next Payment wwwwww Cure Porn Due frum) Non-Term/Operating Loans Adre 254 Weighted Weighted Operating Term Interest Interest Rate Rate 0.00% 0.OON 0.00% OOON 0.00N O.OON 0.00% 0.OON 0.00% O.OON 256 257 258 260 Totals Non-Term Loans Total Accrued interest-acets payable, crcards, non-term loans-transfer to ) Total Balances Due. Non-Term Loans frankerto) 261 Term Loans other than mortgage loans plans for machinery, umet mybe past pa) received or at port Barcelone Duend 12 Month Nortamente Cum Porto De Weighted Term interest Rate 0.OON 262 AD 0.CON 0.00N 264 255 256 267 258 269 270 271 272 273 274 225 0.COM 0.00% 0.COM 0.00% DOON D.OON OOON OOON 0.OON Total Term Loans other than mortages or land contracts Lab 6 BS STUDENT Home Insert Draw Data Review View Tell me Calibri (Body) General insert o Doloso v El Format Paste E Conditional Format Cell Formatting as Table Styles AB End of Year Balance Sheet Schedules for Whisenant Farms Year Ending 2014 Term Loans Mortgage & Land Contracts Curreau 12 Months flow 270 277 278 279 280 Weighted Term interest Rare 0.00 0.00N O.COM O.COM 0.BOX 282 Total More Loans 283 Total Accrued interest and Balances Due.Term Loans transfer to 254 Total Balances fets payable, credit card, non term/operating and term loan balances 285 Operating Debt Weighted Average interest Rate G.OON 286 Term Debt and Loss Carryover Weighted Average interest Rate Q.COM 287 Weighted Average Interest Rate on All Debt DIV/0 288 289 Schedule N: Accrued Expenses/Liability Schedule : Income Taxes Payable Description Accrued 290 stemployer wholding, etc) Balance Federal income Tax Payable Balance Due 292 294 295 296 297 Total Federal Taxes Payable transfer to Non federal income Taxes Payable Total Acerved Dapenses/bytravfertes Total Non-fed income Transfer te 299 300 301 Schedule P: Other Llabilities (notes, contracts and other) Current Intermediate Other Liabilities - Notes and Contracts Balances Balances Long-Term Balances Total Notes and Contracts: Other Liabilities - Other Total Other Liabilities: Total Other Liabilities (Transfer to BS): 2 Normal No Spacing Heading 1 End of the Year Financial Notes for the Balance Sheet Schedules Below is a random set of notes in no particular order of assets, liabilities and other information. Your job is to: 1 transfer these notes to the balance sheet schedules (spreadsheet) provided 2 Jot down any questions you have about what the items are, what they mean and/or explanations you would like of the balance sheet schedules Note, not all information will be used. Ultimately your goal is to complete a balance sheet for the case farm for the year 2014 Inventory of raised crops intended for sale 22,750 bushels of corn worth $3.69 6,000 bushels of soybeans worth $10.00 263 bushels of wheat valued at $5.00/bu. Inventory of raised livestock intended for sale 10 head of feeder cattle weighing 400 lbs each and current price is $1.60 per lb. Raised feed Inventory 1,600 tons of hay worth $113 per ton Sold $27,518 of livestock to John Smith. He has not paid for it yet. 14 days old. It is due in 30 days. Cash held at United Savings for farm checking and savings accounts: $1,503 Have prepaid expenses to: ABC Coop for anhydrous fertilizer, 30 tons at $500 per ton ABC Coop for seed, 70 bags for $294.28/bag John's Bar Supply for 28% liquid fertilizer, 40 tons at $250/ton Purchases on credit with local suppliers include: Argies Diesel shop: 5700 ABC Coop: 5356 Farm & Fleet: $748 32 acres of established growing hay ground has $220 of direct expenses per acre Rented the chisel plow to the Jones family for $20,000, which has not been paid for yet. The payment from them is due next month States) Focus Normal No Spacing Heading 1 Credit card balances: Venture One for $1,025 208 acres of new growing hay ground has $170 per acre of direct expenses Purchased breeding livestock on hand. These were recently purchased and market values are the same as the purchase price. 1 Beef Bull that cost $1,500 o 9 Beef Cows costing $1,800 each o 1 Bred heifer that cost $1,400 o 4 open heifers that cost $600 each There are several buildings and many improvements, but in total the original cost of buildings and improvements was $1,225,643 with accumulated depreciation of $855,268. Based on recent sales of nearby farms, estimated market value today is $824,350 Inventory of raised breeding livestock, base value per head, and current market value information is below. Head Beginning of Year Base Melt Value/Head Value/Head 150 400 Breeding Stock Dairy Calves Head End of Year Base Mrit Value/Head Value/Head 150 400 10 10 1 800 1,050 1 Dairy Bull 800 1,050 185 1.200 1,780 199 1,200 1,625 62 1.000 1,175 65 1.000 1.175 Dairy Cows Dairy Bred Heifers Dairy Open Heifers 80 700 800 87 700 800 Land 390.5 acres purchased in 2004 for $2.875 per acre. Now worth $3,433 per acre o 50 acres purchased in 2014 for $9,000. Now worth $9,000 per acre ited States) O Focus Machinery and Equipment Tractor 1 purchased in 2012 (remember this is 2014) for $225,000. Depreciation is based on straight-line, zero salvage value and 7 years of useful life. "Blue Book" (market value) today is $180,000. Assume the year of purchase was a full year of deprecation Tractor 2 purchased in 2010 for $140,000. Depreciation based on straight-line, zero salvage value and 7 years useful life. "Blue Book" - $75,000 Skaid loader purchased in 2011 for $24,000. Depreciation: straight-line, S4,000 salvage value and 5 years useful life. Blue Book market value = $15,000 All other machinery and equipment have total purchase cost of $650,000, accumulated depreciation of $475,764 and market value today of $521,325. Loans Non-term and Operating loans Operating line of credit: Ourrent balance of $192,879, accrued interest of $488 and 3.04% interest rate (no information on date received or next payment) Risk line of credit for marketing: 3,04% rate, $37 accrued interest and a balance of $14,549 Term Debt . FPP bide/land improvements: 3.28% interest, S1,702 accrued interest, principal due beyond this year of $531,061 and principal due this year of $91,918 FPP Machinery Note: principal due beyond this year of $113,363, principal payment this year of $45,664, 2.65% interest rate and $145 of accrued interest Mortgage and Land contracts Just made a payment on both loans so interest is paid to date, that is, no accrued interest. REM: 3.25% interest rate, long-term balance of $1,253,809 and payment this year of 567,268 Land Contract: 2.85% interest rate, long-term balance of 535,361, principal payment this year of $4,655 Accrued Expenses/Liabilities Employer withholding due but not paid $211 Other assets Vehicles with cost and market value of $19,500 (intermediate Asset) ed States) O Focus Other assets o Vehicles with cost and market value of $19,500 (Intermediate Asset) Investment in ABC Cooperative is long-term (Fixed Asset): $5,482 The following do not go on a schedule, but instead are inputs directly to the balance sheet in the Owner Equity Section Net income this year was $141,226 and the accumulation of past income (past retained earings is $495,207 The sum of capital originally contributed to start the farm and since then totals $240,518. There was zero new capital contributions this year There was no owner withdrawal for any reason and no capital distributions this year