Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Suppose at the end of the year a farm has Total Assets of $1,000.000, of which $200,000 is current assets, $400,000 is Machinery and Breeding

image text in transcribed

Suppose at the end of the year a farm has Total Assets of $1,000.000, of which $200,000 is current assets, $400,000 is Machinery and Breeding Livestock, and $400,000 is Land. Also suppose the firm owes $400,000 in total debt. The specifics regarding the debt are as follows: $150,000 on an operating loan, $150,000 on a machinery loan, of which $32,000 is due within the next year, and $100,000 on a land loan, of which $10,000 is due within the next year. a. (3)Create a simple balance sheet in Excel for this farm with the following categories clearly identified: Current Assets, Long-Term Assets, Total Assets, Current Liabilities, Long-Term Liabilities, Total Liabilities, and Net Worth. b. (3)Calculate a common liquidity" measure for this farm and provide your assessment of the liquidity position of this farm. c. (3Calculate a common "solvency" measure for this farm and provide your assessment of the solvency position of this farm. Last year this farm sold $160,000.00 worth of grain, and $32,000.00 worth of calves. Included in the grain sales were $30,000.00 of grain that had actually been produced the year before but not sold until last year. In addition, at the end of last year the farm had $15,000.00 worth of grain held in inventory that had not been sold. d. (3)In your spreadsheet, calculate accrual revenue for last year based on the above information. | Over the course of last year, the farm had cash operating outflows of $108,200.00, and in addition paid $16,795.00 in interest during the year. Of the operating cash outflows, $6000.00 was for seed they intend to use the following year, however, during the course of last year they did use $7,000.00 worth of fertilizer that they had paid for the year before. They had $16,000.00 in not-cash expenses (management depreciation) last year. They paid off $42,000.00 in principle payments on their equipment and land loans last year, and they purchased two breeding cows for $3500.00, and they purchased a new stock trailer for $8,500.00. They did not sell any equipment. The family withdrew $45,000.00 from the farm account for family living. e. (3)In your spreadsheet, calculate accrual expenses for last year based on the above information f. (3)Calculate Net Farm Income. Suppose at the end of the year a farm has Total Assets of $1,000.000, of which $200,000 is current assets, $400,000 is Machinery and Breeding Livestock, and $400,000 is Land. Also suppose the firm owes $400,000 in total debt. The specifics regarding the debt are as follows: $150,000 on an operating loan, $150,000 on a machinery loan, of which $32,000 is due within the next year, and $100,000 on a land loan, of which $10,000 is due within the next year. a. (3)Create a simple balance sheet in Excel for this farm with the following categories clearly identified: Current Assets, Long-Term Assets, Total Assets, Current Liabilities, Long-Term Liabilities, Total Liabilities, and Net Worth. b. (3)Calculate a common liquidity" measure for this farm and provide your assessment of the liquidity position of this farm. c. (3Calculate a common "solvency" measure for this farm and provide your assessment of the solvency position of this farm. Last year this farm sold $160,000.00 worth of grain, and $32,000.00 worth of calves. Included in the grain sales were $30,000.00 of grain that had actually been produced the year before but not sold until last year. In addition, at the end of last year the farm had $15,000.00 worth of grain held in inventory that had not been sold. d. (3)In your spreadsheet, calculate accrual revenue for last year based on the above information. | Over the course of last year, the farm had cash operating outflows of $108,200.00, and in addition paid $16,795.00 in interest during the year. Of the operating cash outflows, $6000.00 was for seed they intend to use the following year, however, during the course of last year they did use $7,000.00 worth of fertilizer that they had paid for the year before. They had $16,000.00 in not-cash expenses (management depreciation) last year. They paid off $42,000.00 in principle payments on their equipment and land loans last year, and they purchased two breeding cows for $3500.00, and they purchased a new stock trailer for $8,500.00. They did not sell any equipment. The family withdrew $45,000.00 from the farm account for family living. e. (3)In your spreadsheet, calculate accrual expenses for last year based on the above information f. (3)Calculate Net Farm Income

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Entrepreneurial Finance And Accounting For High-Tech Companies

Authors: Frank J Fabozzi

1st Edition

0262336901, 9780262336901

More Books

Students also viewed these Finance questions

Question

What is the use of bootstrap program?

Answered: 1 week ago