Question

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 on a separate page using the information below compiled by Rhonda on January 22, 2019. A Grain on hand a Hay on hand A Growing wheat L Farm mortgage (duel4/1/19) 3500 bu.@ S5.00 per bu. 17500 100 tons @$80.00 per ton tooo 200 acres @ $69.80 per acre 13460 $13,000 principal $10,000 accrued interest $260,000 $68,000 balance after 4/01/19 payment L Note payable on feeder cattle (all due 4/15/19) h Calves (to be sold in May 2019) A Feeder cattle (to be sold in 60 days) L Note payable at bank (all due 3/1/019) A Vehicles A Other machinery & equipment L Loan on beef cows (due 10/01/19) 100 head@ $605 per head &O 125 head@ $800 per head to000 $82,000 $30,500 $130,500 $12,000 principal, $2,200 accrued interest balance after 10/1/15 payment $34,000 1000 acres @ $1800 per acre ItoB, A Land (present market value) A Beef breeding cows A Bulls A Checking account balance L Account payable at Joes Feed &Seed A Account receivable A Shop Equip. (welder, lathe, drill press, etc.) 110 head @$1000 per head 11o,00 4 head @$2,200 each o $33,400- $6,500 $3,600 $5,000 100 shares @ $90 per share 1000 A Corporate Stock Other Information A I) Has paid in advance for $6,000 worth of feed in order to get a good price on it. The foed will be delivered in May, 2019 L 2) Income and social security taxes on 2018 income (not yet paid) are estimated at $14200 Ot 3) Rhonda contributed $590,000 to get her business started OE 4) Retained earnings since the beginning of the business equals $655,000
1. What is Rhondas owners equity as of January 22, 20192 Answer 2. How much working capital does Rhonda have? Answer 3. What is her current ratio? Answer 4. What is her debt/asset ratio? Answer 5. What is her debt/equity ratio? Answer 6. What is her equity/asset ratio? Answer 7. Assume you are a financial consultant hired by Rhonda to analyze her financial condition. Based on this balance sheet, what part of her financial condition is most in need of improvement? WHY What does this balance sheet tell you about the amount of profit Rhonda made in 2013? Explain your answer. 8.
0 0
Add a comment Improve this question Transcribed image text
Answer #1

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)
Add a comment
Know the answer?
Add Answer to:
BALANCE SHEET I. Rhonda Rancher has applied for a loan. Her banker, Larry Loanmaker, says the...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT