BALANCE SHEET Rhonda Rancher has applied for a loan. Her banker, Larry Loanmaker, says the old...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 afternoon taking inventory and gathering other information. Complete the balance sheet on the attached pages using the information below compiled by Rhonda on February 15, 2008. Milo on hand Hay on hand -Growing wheat - Farm mortgage (due4/01/08) -Buildings & improvements - Note payable on feeder cattle (all due 11/15/08) -Calves (to be sold in May 2008) -Feeder cattle (to be sold in 60 days) Note payable at bank (all due 3/1/09) -Vehicles -Other machinery & equipment -Loan on beef cows (due 10/01/08) - -Land (present market value) -Beef breeding cows - Bulls Checking account balance -Account payable at Joe's Feed & Seed -Account receivable -Shop Equip. (welder, lathe, drill press, etc.) -Ford Motor Co. stock Other Information <- 1) 2) -3) 4200 cwt. @ $4.40 per cwt. 75 tons@ $50.00 per ton 280 acres @ $22.50 per acre $14,000 principal $20,000 accrued interest balance after 4/01/08 payment $208,000 $48,000 $34,000 98 head @ $275 per head 138 head @ $575 per head $52,000 $15,500 $80,500 $9,000 principal, $3,900 accrued interesti balance after 10/1/08 payment: $38,000 1020 acres @ $560 per acre 106 head @ $650 per head 4 head@$1,000 each $5,400 $4,200 $1,600 $2,000 200 shares @ $65 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 2008. Income and social security taxes on 2007 income is estimated at $7,200. Rhonda contributed $50,000 to get her business started. Retained earnings since the beginning of the business equals $305,000. 1. 2. 8. 3. 4. 10. What is Rhonda's owner's equity as of February 15, 2008? How much working capital does Rhonda have? What is her current ratio? What is her debu/asset ratio? What is her debt/equity ratio? 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 is her equity/asset ratio? What does this balance sheet tell you about the amount of profit Rhonda made in 2007? Explain your answer. c) Rhonda wants to borrow $50,000 from the bank to buy additional beef breeding cows. They will cost $50,000. Assume the loan is made, the cows are purchased. a) b) What will Rhonda's owner's equity be immediately after the transactions are completed if there are no other changes on her balance sheet? What will her debt/asset ratio be? What will be her debt/equity ratio be? If you were Larry Loanmaker, would you loan Rhonda the money? Why? BALANCE SHEET for ASSETS: 1) Cash 2) Inventories Crops Market Livestock Supplies 3) Accounts Recievable 4) Prepaid Expences 5) Investment in growing crops 6) Other Current Assets: Marketable securities 7) TOTAL CURRENT ASSETS 8) Machinery and Equipment 9) Breeding livestock (purchased) 10) Breeding livestock (raised) 11) Buildings and improvements 12) Land 13) Other noncurrent assets 14) TOTAL NONCURRENT ASSETS 15) TOTAL FARM ASSETS Rhonda Rancher Original $0 $0 $0 w/ Loan $0 $0 $0 As of February 15, 2008 Notes (adds lines 1-6) (adds lines 8-13) (adds lines 7 & 14) 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 afternoon taking inventory and gathering other information. Complete the balance sheet on the attached pages using the information below compiled by Rhonda on February 15, 2008. Milo on hand Hay on hand -Growing wheat - Farm mortgage (due4/01/08) -Buildings & improvements - Note payable on feeder cattle (all due 11/15/08) -Calves (to be sold in May 2008) -Feeder cattle (to be sold in 60 days) Note payable at bank (all due 3/1/09) -Vehicles -Other machinery & equipment -Loan on beef cows (due 10/01/08) - -Land (present market value) -Beef breeding cows - Bulls Checking account balance -Account payable at Joe's Feed & Seed -Account receivable -Shop Equip. (welder, lathe, drill press, etc.) -Ford Motor Co. stock Other Information <- 1) 2) -3) 4200 cwt. @ $4.40 per cwt. 75 tons@ $50.00 per ton 280 acres @ $22.50 per acre $14,000 principal $20,000 accrued interest balance after 4/01/08 payment $208,000 $48,000 $34,000 98 head @ $275 per head 138 head @ $575 per head $52,000 $15,500 $80,500 $9,000 principal, $3,900 accrued interesti balance after 10/1/08 payment: $38,000 1020 acres @ $560 per acre 106 head @ $650 per head 4 head@$1,000 each $5,400 $4,200 $1,600 $2,000 200 shares @ $65 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 2008. Income and social security taxes on 2007 income is estimated at $7,200. Rhonda contributed $50,000 to get her business started. Retained earnings since the beginning of the business equals $305,000. 1. 2. 8. 3. 4. 10. What is Rhonda's owner's equity as of February 15, 2008? How much working capital does Rhonda have? What is her current ratio? What is her debu/asset ratio? What is her debt/equity ratio? 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 is her equity/asset ratio? What does this balance sheet tell you about the amount of profit Rhonda made in 2007? Explain your answer. c) Rhonda wants to borrow $50,000 from the bank to buy additional beef breeding cows. They will cost $50,000. Assume the loan is made, the cows are purchased. a) b) What will Rhonda's owner's equity be immediately after the transactions are completed if there are no other changes on her balance sheet? What will her debt/asset ratio be? What will be her debt/equity ratio be? If you were Larry Loanmaker, would you loan Rhonda the money? Why? BALANCE SHEET for ASSETS: 1) Cash 2) Inventories Crops Market Livestock Supplies 3) Accounts Recievable 4) Prepaid Expences 5) Investment in growing crops 6) Other Current Assets: Marketable securities 7) TOTAL CURRENT ASSETS 8) Machinery and Equipment 9) Breeding livestock (purchased) 10) Breeding livestock (raised) 11) Buildings and improvements 12) Land 13) Other noncurrent assets 14) TOTAL NONCURRENT ASSETS 15) TOTAL FARM ASSETS Rhonda Rancher Original $0 $0 $0 w/ Loan $0 $0 $0 As of February 15, 2008 Notes (adds lines 1-6) (adds lines 8-13) (adds lines 7 & 14)
Expert Answer:
Answer rating: 100% (QA)
To solve these questions well need to analyze Rhondas financial information provided in the first image and calculate various financial ratios and amo... View the full answer
Related Book For
Managerial Accounting
ISBN: 978-0176223311
1st Canadian Edition
Authors: Karen Wilken Braun, Wendy Tietz, Walter Harrison, Rhonda Pyp
Posted Date:
Students also viewed these finance questions
-
Solve the following 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....
-
Lindsay Kay approached her friend Michael Wait about going into business together as co owners of a gardening centre. Lindsay loved gardening and had some skills as an accountant. Michael was a...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
On January 2, 2013, Parker Corporation invests in the stock of Quarry Corporation. Quarry's book value is $4 million and its assets and liabilities are fairly reported. Quarry reports income of $3...
-
Find the Thevenin equivalent of the network shown at the terminals A-B. Tx / 1000 IKO
-
The Cecil-Booker Vending Company changed its method of valuing inventory from the average cost method to the FIFO cost method at the beginning of 2021. At December 31, 2020, inventories were $120,000...
-
What weakness is inherent in the accounting rate of return when it is used as an investment criterion?
-
Two light sources of identical strength are placed 10 m apart. An object is to be placed at a point P on a line parallel to the line joining the light sources and at a distance d meters from it (see...
-
At what nominal rate compounded continuously must money be invested to triple in 9 years? A rate of % is required for money to triple in years. (Do not round until the final answer. Then round to the...
-
In one year, one dollar ($1) could be exchanged for one euro and twenty cents (1.20). a. Derive a formula to exchange dollars into euros. Let d be the number of dollars. Let e be the number of euros....
-
Research suggests many incarcerated women suffer for adverse childhood experiences (ACEs), e.g., abuse, neglect, and chaotic home environments, and adult intimate partner violence (IPV). A sample of...
-
Analyze the RSC offer. How much is the participating feature of the Series E Preferred worth? To do so, answer the following questions: a. (5 Points) Derive a "Capitalization table" that shows how...
-
Car A with mass 3,087 kg collides with stationary 1600 kg Car B. They become locked together after the collision and move with speed 8 m/s. What was the initial speed of Car A?
-
What information is appropriate for making strategic planning decisions and for making operational control decisions? Pick an example of an area for strategic decision making and then describe the...
-
Lease or Sell Felix Company owns equipment with a cost of $365,100 and accumulated depreciation of $54,700 that can be sold for $273,400, less a 5% sales commission. Alternatively, Felo Company can...
-
You have been asked to value the shares of Atlas Enterprises. The company just paid a dividend of $3.50 per share, which is expected to grow at 2% p.a. for the next 3 years. The dividend is then...
-
10-1) A project has an initial cost of $40,000, expected net cash inflows of $9,000 per year for 7 years, and a cost of capital of 11%. What is the project's NPV? (Hint: Begin by constructing a time...
-
The water in tank A is at 270 F with quality of 10% and mass 1 lbm. It is connected to a piston/cylinder holding constant pressure of 40 psia initially with 1 lbm water at 700 F. The valve is opened,...
-
Clegg manufactures radiation-shielding glass panels. Suppose Clegg is considering spending the following amounts on a new TQM program: Strength-testing one item from each batch of...
-
Calculate the margin of safety in units for each of the five years in your projection.
-
List eight key activities performed at this company. Choose at least one activity in the areas of production, sales, human resources, and accounting.
-
Is the Euro Area experiencing a net capital inflow? Use the following balance of payments data for the Euro Area from the IMF to answer this problem. Assumptions (billion US$) 2000 2001 2002 2003...
-
What is the Euro Areas total for Groups A and B? Use the following balance of payments data for the Euro Area from the IMF to answer this problem. Assumptions (billion US$) 2000 2001 2002 2003 2004...
-
What is the Euro Areas total for Groups A through C? Use the following balance of payments data for the Euro Area from the IMF to answer this problem. Assumptions (billion US$) 2000 2001 2002 2003...
Study smarter with the SolutionInn App