I need help putting the notes from the word document into the excel catagories

100% 4-2 Mon 12:49 PM E OFF Excel File Edit View Insert Format Tools Data Window Help AutoSave BES = Home Insert Draw Page Layout Formulas Data Review View Tell me Lab 6 BS STUDENT Q Share 0 Comments B D E F H J KAJ AK AL AM AN AP Year Ending: 2014 1 End of Year Balance Sheet Schedules For: Whisenant Farms 204 asset and anamity with the namity being split between what is que currently and what remains. 205 206 207 Schedule L: Investment in cooperatives and Other Non-Current Investments/Assets (Intermediate and Fixed)? 208 Intermediate Cost Basis BS Mrkt Basis BS Use Cost Value Use Mrkt Value Fixed Cost Basis BS Mrkt Basis BS Use Cost Value Use Mrkt Value Investment in Cooperatives 209 210 211 212 213 214 Total Investment in Cooperatives (transfer to BS): Other Investments (Stocks, Bonds, Securities, etc.) 215 216 217 218 219 220 Total Other Investments : Other Non-Current Assets (titled vehicles, etc.) 221) 222 223 224 225 226 227 Total Other Intermediate and Fixed Assets: Total Other Investments/Assets (Transfer to BS) 228 Includes investments in cooperatives, unpaid cooperative dividends, investment in other entities, where conversion to cash is beyond one year. 229 230 Liability Schedules 231 232 222 Schedule M: Accounte Davahie Cradlit Cards and Debt Service Iterm and non-termlanerating loans! General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + 3 TUU/0 OCT AM 26 0 tvu W C Excel File Edit Data Window Help 100% 4-2 Mon 12:49 PM E View Insert Format Tools HESUS = AutoSave OFF Lab 6 BS STUDENT Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments H J KAJ AK AL AM AN AP mm B D E F G End of Year Balance Sheet Schedules For: Whisenant Farms 2014 Year Ending: 1 233 Schedule M: Accounts Payable, Credit Cards and Debt Service (term and non-term/operating loans) Accounts Payable (Includes: wages, repairs, supplies and inputs, rent, Date incurred Next Payment Date Balance Due 234 etc.) mm/yyy Interest Rate Accrued Interest Due current liab.) 235 236 237 238 239 240 241 242 243 244 Total Accounts Payable: Date Incurred Next Payment Date Balance Due 245 Credit Cards mm/yyyy mm/yyy Interest Rate Accrued Interest Due (current liab.) 246 Venture One 247 248 249 250 251 Total Credit Cards 0 252 Total Accounts Payable & Credit Cards (transfer to BS): Date Loan Loss Carryover received or last Balance Due Beyond prt date Next Payment Date Current Portion Due 12 Months 253 Non-Term/Operating Loans mm/ww mm/wwy Interest Rate Accrued Interest Due (current liab. (Intermediate) 254 255 256 257 258 259 Totals Non-Term Loans: 260 Total Accrued interest -accis Davable. Cr. Cards. non-term loans-itransfer to si General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + Weighted Weighted Operating Term Interest Interest Rate Rate 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% % 3 + 100% OCT AM 26 (tv M 4 W Window Help 100% 4-2 Mon 12:49 PM E Excel File Edit View Insert Format Tools Data AutoSave BES OFF Lab 6 BS STUDENT Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments F . J KAJ AK AL AM AN AP Year Ending: 2014 B D E End of Year Balance Sheet Schedules For: Whisenant Farms Total Accrued Interest - accts payable, cr. cards, non-term loans - (transfer to BS) Total Balances Due - Non-Term Loans -(transfer to BS): 1 1 260 261 Term Loans (other than mortgage loans) (loans for machinery, equipment, & maybe past operating, etc.) Date Loan received or last pmt date mm/yyy Next Payment Date mm/yyy Current Portion Due (current liabil Balance Due Beyond Balance Due Beyond 12 Months 12 Months Intermediate) (Long-Term Interest Rate Accrued Interest Due 262 263 264 265 266 267 268 269 270 271 272 273 274 275 Weighted Term Interest Rate 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Total Term Loans other than mortgages or land contracts: Date Loan received or last pmt date Next Payment Date mm/yyy mm/yyy Interest Rate Term Loans Mortgage & Land Contracts Balance Due Beyond Balance Due Beyond 12 Months 12 Months Intermediate) (Long-Term Current Portion Due (current liab.) Accrued Interest Due Weighted Term Interest Rate 0.00% 0.00% 0.00% 0.00% 0.00% % 276 277 278 279 280 281 282 283 284 285 286 287 288 Total Mortgage Loans: Total Accrued Interest and Balances Due - Term Loans - (transfer to BS): Total Balances (accts payable, credit card, non-term/operating, and term loan balances): Operating Debt Weighted Average Interest Rate: Term Debt and Loss Carryover Weighted Average Interest Rate: Weighted Average Interest Rate on All Debt 0.00% 0.00% #DIV/0! General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + 3 + 100% OCT AM 26 0 ctv 4 W 100% 4-2 Mon 12:49 PM E OFF Excel File Edit View Insert Format Tools Data Window Help AutoSave HESU- Home Insert Draw Page Layout Formulas Data Review View Tell me Lab 6 BS STUDENT Q Share 0 Comments B D E F . J KAJ AK AL AM AN AP End of Year Balance Sheet Schedules For: Whisenant Farms Year Ending: 2014 1 289 Schedule N: Accrued Expenses/Liability Schedule 0: Income Taxes Payable Description Accrued 290 (wages payable, RE taxes, employer withholding, etc.) Balance Federal Income Taxes Payable Balance Due 291 292 293 294 Total Federal Taxes Payable (transfer to BS) 295 Non-Federal Income Taxes Payable Balance Due 296 297 298 299 Total Accrued Expenses/Liability (transfer to BS): Total Non-Fed Income Taxes (transfer to BS): 300 301 302 Schedule P: Other Liabilities (notes, contracts and other) Current Intermediate Long-Term 303 Other Liabilities - Notes and Contracts Balances Balances Balances 304 305 306 307 308 309 Total Notes and Contracts: Other Liabilities - Other 310 311) 312 313 314 315 316 317 318 319 Total Other Liabilities: Total Other Liabilities (Transfer to BS): General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + 3 TUU/0 AM 26 0 tvm W C AutoSave OFF os 5- w Lab 6 BS STUDENT - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share o Comments Calibri (Bo... v 14 V A cDde AaBbCcDdEe " AI Aav A X APA AaBbCcDc AaBbCcDdEt AaBbc Paste B I U v ab v ale X Normal V Title 15 No Spacing Dictate Heading 1 V Heading 2 Styles Pane Sensitivity 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 o 22,750 bushels of corn worth $3.69 6,000 bushels of soybeans worth $10.00 o 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 o 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 o John's AgriSupply for 28% liquid fertilizer, 40 tons at $250/ton Purchases on credit with local suppliers include: Argies Diesel shop: $700 ABC Coop: $356 O 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. Page 2 of 6 1340 words English (United States) O Focus E + 90% AutoSave OFF os 5- w Lab 6 BS STUDENT - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share o Comments Calibri (Bo... v 14 V A AaBbCcDdEe AaBbCcDdEe " AI Aav A X APA AaBbCcDc AaBbCcDdEt AaBbc Paste B I U v ab v ale X Normal No Spacing Heading 1 V Title Heading 2 Dictate Styles Pane Sensitivity 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. o 1 Beef Bull that cost $1,500 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. Beginning of Year Base Mrkt Value/Head Value/Head Head Breeding Stock Dairy Calves Head End of Year Base Mrkt Value/Head Value/Head 150 400 10 150 400 10 Dairy Bull 1 800 1,050 1 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 50 acres purchased in 2014 for $9,000. Now worth $9,000 per acre Page 3 of 6 1340 words English (United States) Focus E + 90% AutoSave OFF os 5- w Lab 6 BS STUDENT - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share o Comments Calibri (Bo... v 14 V AL cDde AaBbCcDdEe " AI Aav A X APA AaBbCcDc AaBbCcDdEt AaBbc Paste B I U v ab v ale X Normal 19 No Spacing V Heading 1 Title Heading 2 Dictate Styles Pane Sensitivity 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 depreciation. o 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. Skid loader purchased in 2011 for $24,000. Depreciation straight-line, $4,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: Current 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,649 Term Debt FPP bldg./land Improvements: 3.28% interest, $1,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 o 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 $67,268 Land Contract: 2.85% interest rate, long-term balance of $35,361, principal payment this year of $4,655 Accrued Expenses/Liabilities Employer withholding due but not paid: $213 Other assets o Vehicles with cost and market value of $19,500 (Intermediate Asset) Page 4 of 6 1340 words English (United States) Focus E + 90% 100% 4-2 Mon 12:49 PM E OFF Excel File Edit View Insert Format Tools Data Window Help AutoSave BES = Home Insert Draw Page Layout Formulas Data Review View Tell me Lab 6 BS STUDENT Q Share 0 Comments B D E F H J KAJ AK AL AM AN AP Year Ending: 2014 1 End of Year Balance Sheet Schedules For: Whisenant Farms 204 asset and anamity with the namity being split between what is que currently and what remains. 205 206 207 Schedule L: Investment in cooperatives and Other Non-Current Investments/Assets (Intermediate and Fixed)? 208 Intermediate Cost Basis BS Mrkt Basis BS Use Cost Value Use Mrkt Value Fixed Cost Basis BS Mrkt Basis BS Use Cost Value Use Mrkt Value Investment in Cooperatives 209 210 211 212 213 214 Total Investment in Cooperatives (transfer to BS): Other Investments (Stocks, Bonds, Securities, etc.) 215 216 217 218 219 220 Total Other Investments : Other Non-Current Assets (titled vehicles, etc.) 221) 222 223 224 225 226 227 Total Other Intermediate and Fixed Assets: Total Other Investments/Assets (Transfer to BS) 228 Includes investments in cooperatives, unpaid cooperative dividends, investment in other entities, where conversion to cash is beyond one year. 229 230 Liability Schedules 231 232 222 Schedule M: Accounte Davahie Cradlit Cards and Debt Service Iterm and non-termlanerating loans! General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + 3 TUU/0 OCT AM 26 0 tvu W C Excel File Edit Data Window Help 100% 4-2 Mon 12:49 PM E View Insert Format Tools HESUS = AutoSave OFF Lab 6 BS STUDENT Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments H J KAJ AK AL AM AN AP mm B D E F G End of Year Balance Sheet Schedules For: Whisenant Farms 2014 Year Ending: 1 233 Schedule M: Accounts Payable, Credit Cards and Debt Service (term and non-term/operating loans) Accounts Payable (Includes: wages, repairs, supplies and inputs, rent, Date incurred Next Payment Date Balance Due 234 etc.) mm/yyy Interest Rate Accrued Interest Due current liab.) 235 236 237 238 239 240 241 242 243 244 Total Accounts Payable: Date Incurred Next Payment Date Balance Due 245 Credit Cards mm/yyyy mm/yyy Interest Rate Accrued Interest Due (current liab.) 246 Venture One 247 248 249 250 251 Total Credit Cards 0 252 Total Accounts Payable & Credit Cards (transfer to BS): Date Loan Loss Carryover received or last Balance Due Beyond prt date Next Payment Date Current Portion Due 12 Months 253 Non-Term/Operating Loans mm/ww mm/wwy Interest Rate Accrued Interest Due (current liab. (Intermediate) 254 255 256 257 258 259 Totals Non-Term Loans: 260 Total Accrued interest -accis Davable. Cr. Cards. non-term loans-itransfer to si General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + Weighted Weighted Operating Term Interest Interest Rate Rate 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% % 3 + 100% OCT AM 26 (tv M 4 W Window Help 100% 4-2 Mon 12:49 PM E Excel File Edit View Insert Format Tools Data AutoSave BES OFF Lab 6 BS STUDENT Q Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments F . J KAJ AK AL AM AN AP Year Ending: 2014 B D E End of Year Balance Sheet Schedules For: Whisenant Farms Total Accrued Interest - accts payable, cr. cards, non-term loans - (transfer to BS) Total Balances Due - Non-Term Loans -(transfer to BS): 1 1 260 261 Term Loans (other than mortgage loans) (loans for machinery, equipment, & maybe past operating, etc.) Date Loan received or last pmt date mm/yyy Next Payment Date mm/yyy Current Portion Due (current liabil Balance Due Beyond Balance Due Beyond 12 Months 12 Months Intermediate) (Long-Term Interest Rate Accrued Interest Due 262 263 264 265 266 267 268 269 270 271 272 273 274 275 Weighted Term Interest Rate 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% Total Term Loans other than mortgages or land contracts: Date Loan received or last pmt date Next Payment Date mm/yyy mm/yyy Interest Rate Term Loans Mortgage & Land Contracts Balance Due Beyond Balance Due Beyond 12 Months 12 Months Intermediate) (Long-Term Current Portion Due (current liab.) Accrued Interest Due Weighted Term Interest Rate 0.00% 0.00% 0.00% 0.00% 0.00% % 276 277 278 279 280 281 282 283 284 285 286 287 288 Total Mortgage Loans: Total Accrued Interest and Balances Due - Term Loans - (transfer to BS): Total Balances (accts payable, credit card, non-term/operating, and term loan balances): Operating Debt Weighted Average Interest Rate: Term Debt and Loss Carryover Weighted Average Interest Rate: Weighted Average Interest Rate on All Debt 0.00% 0.00% #DIV/0! General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + 3 + 100% OCT AM 26 0 ctv 4 W 100% 4-2 Mon 12:49 PM E OFF Excel File Edit View Insert Format Tools Data Window Help AutoSave HESU- Home Insert Draw Page Layout Formulas Data Review View Tell me Lab 6 BS STUDENT Q Share 0 Comments B D E F . J KAJ AK AL AM AN AP End of Year Balance Sheet Schedules For: Whisenant Farms Year Ending: 2014 1 289 Schedule N: Accrued Expenses/Liability Schedule 0: Income Taxes Payable Description Accrued 290 (wages payable, RE taxes, employer withholding, etc.) Balance Federal Income Taxes Payable Balance Due 291 292 293 294 Total Federal Taxes Payable (transfer to BS) 295 Non-Federal Income Taxes Payable Balance Due 296 297 298 299 Total Accrued Expenses/Liability (transfer to BS): Total Non-Fed Income Taxes (transfer to BS): 300 301 302 Schedule P: Other Liabilities (notes, contracts and other) Current Intermediate Long-Term 303 Other Liabilities - Notes and Contracts Balances Balances Balances 304 305 306 307 308 309 Total Notes and Contracts: Other Liabilities - Other 310 311) 312 313 314 315 316 317 318 319 Total Other Liabilities: Total Other Liabilities (Transfer to BS): General Farm & Financial Info BS Schedules Beginning & Ending BS Deferred Taxes + 3 TUU/0 AM 26 0 tvm W C AutoSave OFF os 5- w Lab 6 BS STUDENT - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share o Comments Calibri (Bo... v 14 V A cDde AaBbCcDdEe " AI Aav A X APA AaBbCcDc AaBbCcDdEt AaBbc Paste B I U v ab v ale X Normal V Title 15 No Spacing Dictate Heading 1 V Heading 2 Styles Pane Sensitivity 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 o 22,750 bushels of corn worth $3.69 6,000 bushels of soybeans worth $10.00 o 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 o 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 o John's AgriSupply for 28% liquid fertilizer, 40 tons at $250/ton Purchases on credit with local suppliers include: Argies Diesel shop: $700 ABC Coop: $356 O 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. Page 2 of 6 1340 words English (United States) O Focus E + 90% AutoSave OFF os 5- w Lab 6 BS STUDENT - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share o Comments Calibri (Bo... v 14 V A AaBbCcDdEe AaBbCcDdEe " AI Aav A X APA AaBbCcDc AaBbCcDdEt AaBbc Paste B I U v ab v ale X Normal No Spacing Heading 1 V Title Heading 2 Dictate Styles Pane Sensitivity 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. o 1 Beef Bull that cost $1,500 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. Beginning of Year Base Mrkt Value/Head Value/Head Head Breeding Stock Dairy Calves Head End of Year Base Mrkt Value/Head Value/Head 150 400 10 150 400 10 Dairy Bull 1 800 1,050 1 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 50 acres purchased in 2014 for $9,000. Now worth $9,000 per acre Page 3 of 6 1340 words English (United States) Focus E + 90% AutoSave OFF os 5- w Lab 6 BS STUDENT - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Tell me Share o Comments Calibri (Bo... v 14 V AL cDde AaBbCcDdEe " AI Aav A X APA AaBbCcDc AaBbCcDdEt AaBbc Paste B I U v ab v ale X Normal 19 No Spacing V Heading 1 Title Heading 2 Dictate Styles Pane Sensitivity 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 depreciation. o 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. Skid loader purchased in 2011 for $24,000. Depreciation straight-line, $4,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: Current 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,649 Term Debt FPP bldg./land Improvements: 3.28% interest, $1,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 o 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 $67,268 Land Contract: 2.85% interest rate, long-term balance of $35,361, principal payment this year of $4,655 Accrued Expenses/Liabilities Employer withholding due but not paid: $213 Other assets o Vehicles with cost and market value of $19,500 (Intermediate Asset) Page 4 of 6 1340 words English (United States) Focus E + 90%