Solution:
Balance Sheet | ||||||
Assets | USD | USD | Liabilities | USD | USD | |
Non-current assets | Current liabilities | |||||
Buildings | 68000 | Notes payable | 45000 | |||
Vehicles | 30500 | Bank - notes payable | 82000 | |||
Other machinery | 130500 | Accounts payable | 6500 | |||
Land | 1221140 | Security tax | 14200 | 147700 | ||
Beef | 11000 | |||||
Bulls | 8800 | Non current loan | ||||
Shop equipment | 5000 | 1474940 | Farm mortgage | 270000 | ||
Current assets | interest accrued | 10000 | ||||
calves | 60500 | Loan on beef cows | 34000 | |||
Feeder | 100000 | interest accrued | 2200 | 316200 | ||
Prepaid | 6000 | Owners equity and retained earnings | ||||
Accounts receivable | 3600 | Retained earnings | 655000 | |||
Inventory | 39460 | Owners equity | 599000 | 1254000 | ||
Cash | 33400 | 242960 | ||||
1717900 | 1717900 | |||||
Inventory | ||||||
USD | ||||||
Grain | 17500 | |||||
Hay | 8000 | |||||
Growing | 13960 | |||||
Total | 39460 | |||||
1 | Owner equity | 599000 | ||||
2 | Working capital | 95260 | ||||
( Current assets- current liabilities) | ||||||
3 | Current ratio | 1.42 | ||||
(current assets less cash/current liab | ||||||
4 | Debt/asset ratio | 0.18 | ||||
(non - current loan/total assets) | ||||||
5 | Equity/asset ratio | 0.73 | ||||
( Owner equity+retained earnings/assets) |
BALANCE SHEET I. Rhonda Rancher has applied for a loan. Her banker, Larry Loanmaker, says the...
BALANCE SHEET I. Rhonda Rancher has applied for a loan. Her banker, Larry Loanmaker, says the old balance sheet on file must be brought up to date before a loan will be considered. Rhonda spends the rest of the afternoon taking inventory and gathering other information. Complete a balanee sheet on a separate page using the information below compiled by Rhonda on January 22, 2019. 3500 bu. @ $5.00 per bu. 100 tons @ $80.00 per ton Grain on hand...
Rhonda Rancher has applied for a loan. Her banker, Larry Loanmaker, says the old balance sheet on file must be brought up to date before a loan will be considered. Rhonda spends the rest of the aftermoon taking inventory and gathering other information. In a new spreadsheet file, create a current Market Basis balance sheet for Rhonda dated February 1, 2020. Do not use any pre made templates. I want you to create the balance sheet from scratch. Use the...
Complete a balance sheet on a separate page using the information below compiled by Rhonda on January 22, 2019. Grain on hand 3500 bu. @ $5.00 per bu. Hay on hand 100 tons @ $80.00 per ton Growing wheat 200 acres @ $69.80 per acre Farm mortgage (due/4/1/19) $13,000 principal $10,000 accrued interest balance after 4/01/19 payment $260,000 Buildings & improvements $68,000 Note payable on feeder cattle (all due 4/15/19) $45,000 Calves (to be sold in May 2019) 100 head...
Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet, and evaluate it. The information was gathered on 2/1/18 Grain sorghum in storage 4100 cwt @ $5.40 per cwt Hay on hand 75 ton @ $50.00 per ton Growing wheat 285 acres @ 24.50 per acre invested Farm mortgage payment due 4/7/18 $16,000 principle, $20,200 interest balance after 4/7/18 payment $228,000 Building...
Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet, and evaluate it. The information was gathered on 2/1/18 Grain sorghum in storage 4100 cwt @ $5.40 per cwt Hay on hand 75 ton @ $50.00 per ton Growing wheat 285 acres @ 24.50 per acre invested Farm mortgage payment due 4/7/18 $16,000 principle, $20,200 interest balance after 4/7/18 payment $228,000 Building...
Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet, and evaluate it. The information was gathered on 2/1/18 Grain sorghum in storage 4100 cwt @ $5.40 per cwt Hay on hand 75 ton @ $50.00 per ton Growing wheat 285 acres @ 24.50 per acre invested Farm mortgage payment due 4/7/18 $16,000 principle, $20,200 interest balance after 4/7/18 payment $228,000 Building...
Part 4 - Balance Sheet ***** The Balance Sheet is incomplete. Sterling has almost completed his balance sheet, but needs help with the following 4 pieces of information. Please add the information below and complete Sterling's balance sheet on the next page. 1. He has a balance of $5,400 in his checking account 2. He owes the feed store$4,200 3. Currently owns $4,000 worth of breeding bulls used in the cow-calf operation. 4. Lastly, Sterling owes $38,000 on the cow...
Brian has a loan on a round baler. List all the places on the balance sheet where we would see information related to this loan (give the line name and section of the balance sheet each would be on)? List two effects/impacts of completely writing off (depreciating) a tractor the year it is purchased? Dustin purchased a new grain harvester using money from his operating loan. How would this affect his liquidity? What might it do to working capital and...
How do I calculate the year-end bank loan balance for this question? Lydia’s sale grew by 30% in 2018 and 25% in 2019. She excepts similar growth in 2020, but this is straining her cash reserves. Her bank is concerned about her loan amount exceeding $100,000. Because the fishing season effectively ends in late fall, Lydia’s accountant has completed the financials for 2019. There may be some small changes, but the current 2019 numbers are sufficiently accurate for 2020 planning purposes. Use the...
Question 6 The comparative balance sheet for the financial year ended June 30 for Great Road Trips is as follows: Question 6 The comparative balance sheet for the financial year ended June 30 for Great Road Trips is as follows: Great Road Trips Ltd. Comparative Statements of Financial Position As at 30/06/2019 As at 30/06/2018 $ $ Current Assets Cash 90,000 85,000 Accounts Receivable 30,000 40,000 Less: Allowance for Bad Debts 3,900 2,400 Supplies 200 300 Prepaid Insurance 1,320 1,200...