Balance Sheet And Income Statement Worksheet printable pdf download

Balance Sheet And Income Statement Worksheet

AAE 320 Problem Set #5

Due November 7, 2016

Name___________________

For this problem, you will use a balance sheet and income statement for a hypothetical farm.

The balance sheet and income statement are based on an excel spreadsheet previously available

from Iowa State University Extension. Use this example for this problem

set:

. The spreadsheet has several tabs;

use the Balance Sheet and Income Statement tabs.

a) Fill in the super brief version of the farm balance sheet below using the information in the

Balance Sheet table of the spreadsheet.

Assets

Liabilities

1/1/2015

1/1/2016

1/1/2015

1/1/2016

Current

Non-Current

Equity

Total Assets

Total Liabilities & Equity

b) Using the Balance Sheet from part a,

What was the Current Ratio on 1/1/2015 and on 1/1/2016?

ii)

What was the Debt to Asset Ratio on 1/1/2015 and on 1/1/2016?

iii)

What was the Equity to Asset Ratio on 1/1/2015 and on 1/1/2016?

iv)

What was the Debt to Equity Ratio on 1/1/2015 and on 1/1/2016?

Briefly comment on these ratios: How is the farm doing?

Balance Sheet And Income Statement Worksheet