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 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 Hay on hand Growing wheat Farm mortgage (due/4/1/19) Buildings & improvements Note payable on feeder cattle (all due 4/15/19) Calves (to be sold in May 2019) Feeder cattle (to be sold in 60 days) Note payable at bank (all due 3/1/019) Vehicles Other machinery & equipment Loan on beef cows (due 10/01/19) 200 acres @ S69.80 per acre $13,000 principal $10,000 accrued interest balance after 4/01/19 payment $260,000 $68,000 $45,000 100 head@$605 per head 125 head @ $800 per head $82,000 $30,500 $130,500 $12,000 principal, 2,200 accrued interest balance after 10/1/15 payment $34,000 Land (present market value) Beef breeding cows Bulls Checking account balance Account payable at Joes Feed & Seed Account receivable Shop Equip. (welder, lathe, drill press, etc.) Corporate Stock 1000 acres @$1800 per acre 110 head @ $1000 per head 4 head @ $2,200 each $33,400 S6,500 $3,600 $5,000 100 shares @ $90 per share Has paid in advance for $6,000 worth of feed in order to get a good price on it. The feed will be delivered in May, 2019. 1) 2) Income and social security taxes on 2018 income (not yet paid) are estimated at $14,200. 3) Rhonda contributed $590,000 to get her business started 4) Retained earnings since the beginning of the business equals $655,000.
1. What is Rhondas owners equity as of January 22, 2019? 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? 8. What does this balance sheet tell you about the amount of profit Rhonda made in 2013?
9. Rhonda wants to borrow $40,000 from the bank to buy additional beef breeding cows. They will cost $40,000. Assume the loan is made, the cows are purchased. a) What will Rhondas owners equity be immediately after the transactions are completed if there are no other changes on her balance sheet? Answer b) What will her debt/asset ratio be? Answer c) What will be her debt/equity ratio be? Answer 10. If you were Larry Loanmaker, would you lend Rhonda the money? Why?
0 0
Add a comment Improve this question Transcribed image text
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 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...

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

  • I need answers. Santana Rey has consulted with her local banker and is considering financing an...

    I need answers. Santana Rey has consulted with her local banker and is considering financing an expansion of her business by obtaining a long-term bank loan. Selected account balances at March 31, 2018, for Business Solutions follow. Total assets $120,768 Total liabilities $870 Total equity $119,898 Required: 1. The bank has offered a long-term secured note to Business Solutions. The bank's loan procedures require that a client's debt-to- equity ratio not exceed 0.85. As of March 31, 2018, what is...

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

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