ents-198 ABUSI21-02 x ev/pid 4000605-dt-content-n ABUS 321 (2 Questions-20 points) Assignmenti6 Due: October 30, 2019 at the beginning of class Name: Question 1 Rhonda Rancher operates a ranch, and she wants to apply for a loan to cover her operating expenses for the next year. She scheduled an appointment to visit his banker. Her banker asked her to bring her updated balance sheet. She has hired you to prepare a balance sheet for her using the information below compiled by her on December 31, 2018. Based on the information Rancher has given you, construct a balance sheet (probably in Excel) for her operation as of December 31, 2018 using the standard balance sheet format. Accounts payable Accounts receivable 4,200 1,600 Accrued interest Breeding livestock Inventory-livestock uildings and improvements Checking account Income taxes payable Land Prepaid expenses Machines and equipment Real estate mortgage balance after next payment Real estate mortgage payment due within 12 months Machinery- Loan balance after next payment Machinery - Loan payment due in the next 12 months 23,900 72,900 106,300 48,000 18,400 7,200 571,200 6,000 98,000 208,000 86,000 38000 23,000 Or e ents-198 ABUSI21-02 x ev/pid 4000605-dt-content-n ABUS 321 (2 Questions-20 points) Assignmenti6 Due: October 30, 2019 at the beginning of class Name: Question 1 Rhonda Rancher operates a ranch, and she wants to apply for a loan to cover her operating expenses for the next year. She scheduled an appointment to visit his banker. Her banker asked her to bring her updated balance sheet. She has hired you to prepare a balance sheet for her using the information below compiled by her on December 31, 2018. Based on the information Rancher has given you, construct a balance sheet (probably in Excel) for her operation as of December 31, 2018 using the standard balance sheet format. Accounts payable Accounts receivable 4,200 1,600 Accrued interest Breeding livestock Inventory-livestock uildings and improvements Checking account Income taxes payable Land Prepaid expenses Machines and equipment Real estate mortgage balance after next payment Real estate mortgage payment due within 12 months Machinery- Loan balance after next payment Machinery - Loan payment due in the next 12 months 23,900 72,900 106,300 48,000 18,400 7,200 571,200 6,000 98,000 208,000 86,000 38000 23,000 Or e