Given the above Finacail Statemtns, Calculate all of the missing performance measures in sheet “PM” (below) for Vandelay Farms.“CF” is the statement of cash flow summary for Vandelay Farms. Based on the performance ratios, is Vandelay Farms in any kind of financial trouble? Why or why not?
Answer :
Interest Coverage ratio = EBIT/Interest expense
where EBIT = Earning before interest and tax
2014
Net income from operation = 33079
Interest expense = 34754
EBIT = Net income from operation + Interest expense (33079 + 34754) = 67833
Interest Coverage ratio = EBIT/Interest expense = 67833/34754 = 1.95 approx.
Term debt and lease service coverage ratio = Net operating income / Total debt service
EBIT = Net income from operation + Interest expense (33079 + 34754) = 67833
Total debt = 561097
Term debt and lease service coverage ratio = 67833/561097 = 0.12 approx.
Capital Debt Repayment Capacity = Net Income + Depreciation Expense + Non-Farm/Business Income – Family Living Expenses & Income Taxes + Interest Expense on Term Loans=33079 + 28156 + 24156 – 7011 + 19563= 97943
2015
Net income from operation = 40875
Interest expense = 35989
EBIT = Net income from operation + Interest expense (40875 + 35989) = 76864
Interest Coverage ratio = EBIT/Interest expense = 76864/35989= 2.14 approx.
Term debt and lease service coverage ratio = Net operating income / Total debt service
EBIT = Net income from operation + Interest expense (40875 + 35989) = 76864
Total debt = 563697
Term debt and lease service coverage ratio = 76864/563697 = 0.13 approx.
Capital Debt Repayment Capacity = Net Income + Depreciation Expense + Non-Farm/Business Income – Family Living Expenses & Income Taxes + Interest Expense on Term Loans=40875+ 24346+ 27552– 4360+ 20063= 124402
Capital Debt Repayment Margin = Capital Debt Repayment Capacity – scheduled principal and interest on term loans and leases = 108476– (4178+ 20063) = 84235
Replacement margin ratio = Capital Debt Repayment Capacity / (scheduled loans and leases + cash use to purchase replace asset) = 108476/ (4178+ 20063+ 6158) = 3.568
2016
Net income from operation = 38730
Interest expense = 37664
EBIT = Net income from operation + Interest expense (38730 + 37664) = 76394
Interest Coverage ratio = EBIT/Interest expense = 76394/37664= 2.02 approx.
Term debt and lease service coverage ratio = Net operating income / Total debt service
EBIT = Net income from operation + Interest expense (38730 + 37664) = 76394
Total debt = 563963
Term debt and lease service coverage ratio = 76394/563963 = 0.135 approx.
Capital Debt Repayment Capacity = Net Income + Depreciation Expense + Non-Farm/Business Income – Family Living Expenses & Income Taxes + Interest Expense on Term Loans=38730+ 26285+ 29206– 7603+ 19976= 126570
Capital Debt Repayment Margin = Capital Debt Repayment Capacity – scheduled principal and interest on term loans and leases = 126570– (13789+ 19976) = 92805
Replacement margin ratio = Capital Debt Repayment Capacity / (scheduled loans and leases + cash use to purchase replace asset) = 126570/ (13789+ 19976+ 23489) = 1.995
2017
Net income from operation = 43389
Interest expense = 35585
EBIT = Net income from operation + Interest expense (43389 + 35585) = 78974
Interest Coverage ratio = EBIT/Interest expense = 78974/35585= 2.22 approx.
Term debt and lease service coverage ratio = Net operating income / Total debt service
EBIT = Net income from operation + Interest expense (43389 + 35585) = 78974
Total debt = 564833
Term debt and lease service coverage ratio = 78974/564833 = 0.139 approx.
Capital Debt Repayment Capacity = Net Income + Depreciation Expense + Non-Farm/Business Income – Family Living Expenses & Income Taxes + Interest Expense on Term Loans=43389+ 27237+ 28308– 6686 + 19221= 111469
Capital Debt Repayment Margin = Capital Debt Repayment Capacity – scheduled principal and interest on term loans and leases = 111469– (12432+ 19221) = 79816
Replacement margin ratio = Capital Debt Repayment Capacity / (scheduled loans and leases + cash use to purchase replace asset) = 111469/ (12432+ 19221+ 26879) = 1.904
2018
Net income from operation = 42069
Interest expense = 35780
EBIT = Net income from operation + Interest expense (42069 + 35780) = 77849
Interest Coverage ratio = EBIT/Interest expense = 77849/35780= 2.17 approx.
Term debt and lease service coverage ratio = Net operating income / Total debt service
EBIT = Net income from operation + Interest expense (42069 + 35780) = 77849
Total debt = 566171
Term debt and lease service coverage ratio = 77849/566171 = 0.137 approx.
Capital Debt Repayment Capacity = Net Income + Depreciation Expense + Non-Farm/Business Income – Family Living Expenses & Income Taxes + Interest Expense on Term Loans=42069 + 29201 + 29364 – 2877 + 19079= 116836
Replacement margin ratio = Capital Debt Repayment Capacity / (scheduled loans and leases + cash use to purchase replace asset) = 116836/ (0 + 115648) = 1.010
Conclusion :
Based on performance ratio, Vandelay firm is not in any kind of trouble, as over the years the debt service coverage ratio has increased. The financial position of the company is sound.
Given the above Finacail Statemtns, Calculate all of the missing performance measures in sheet “PM” (below)...
given: Calculate all of the missing performance measures in the sheet “Performance Measures for Vandelay Farms" seen below. “CF” is the statement of cash flow summary for Vandelay Farms. Based on the performance ratios, is Vandelay Farms in any kind of financial trouble? Why or why not? We were unable to transcribe this imageWe were unable to transcribe this imageStatement of Cash Flow Summary for Vandelay Farms Pro farma Cash flows from operating activities 2018 Cash received from farm production...
Review Problems 1 Given the following financial information, calculate the missing values $1,000 95,000 Cash Crop revenue Grain inventory Total operating expenses Prepaid expenses Notes payable Accrued interest Interest expense Supplies Owner equity 200 10,000 Machinery and equipment Farm real estate Total current assets $75,000 Total current liabilities 150,000 Accounts payable 17,500 Cash investment in growing 14,000 crops 2.000 Net farm income from 800 operations 27,000 Current portion of noncurrent 1.500 debt Deferred portion of noncurrent debt 10,000 500 138,500...
Complete the SOE and worksheet using the information below. Change Excess of Market over Book Values (Market - Book) Item: 12/31/2018 Machinery and Equipment -$10,000 Land $0 Buildings $0 Marketable Securities $13,000 Other Investments (local brewery) $20,000 12/31/2019 $5,000 $5,000 $10,000 $5,000 $22,000 Selected Account Balances: Current Deferred Taxes Non-current Deferred Taxes Non-real estate long-term loan balance Total Equity $2,492 $3,000 $165,000 $232,009 $1,359 $12,601 $220,000 $323,041 $91,032 Other Information: 2019 Net Income for Illini Tap was: $151,633 No capital...
complete the following balance sheet. Assets 12/31/2018 12/31/2019 Change Cash $25,000 $35,000 Marketable Securities $10,000 $15,000 Accounts Receivable $1,500 $1,500 Fertilizer and Supplies $500 $25,000 Investments in Growing Crops $48,500 $86,000 Crops held for Sale and Feed $12,000 $8,000 Market Livestock $75,000 $115,000 Total Current Assets Breeding Livestock $45,000 $35,000 Machinery and Equipment $350,000 $315,000 Buildings $75,000 $85,000 Investments in Cooperatives $2,000 $2,000 Land $500,000 $525,000 Total Non-Current Assets Total Assets Flag this Question Question 211.5 pts Complete the following...
1) calculate Free Cash Flows to Equity for 2018. Include cash in all measures of working capital for purposes of these calculations: Jimmy's Corp. Annual Income Statements For Years Ending December 31 Sales Cost of sales Gross profit 2017 $156,121,419 55.330.466 100,790,953 2018 $173,219,147 60.213.877 113,005,270 Net operating expenses Operating income 84.109.861 16,681,092 94.003.364 19,001,906 Other income (expense) Interest expense (1,629,942) (1,680,884) (981,955) (2,109,889) Pretax net income 13,370,266 15,910,062 Taxes (sub S) Net income (loss) $13,370,266 $15,910,062 2018 Jimmy's Corp....
USE THE INFORMATION BELOW TO ANSWER THE FOLLOWING 3 QUESTIONS Mellon Company Balance Sheet For the Years Ending December 31, 2015 and 2016 (All figures in dollars) Cash Account receivable Inventory Total current assets Gross fixed assets (Accumulated depreciation) Net fixed assets Total assets 2015 1,800 4,010 10,100 15,910 55,800 (9,760) 46,040 61,950 2016 1,840 4,210 9,450 15,500 63,840 (11,050) 52,790 68,290 Notes payable Accounts payable Accruals Current portion of LT debt Total current liabilities Lont-term debt Common stock Paid...
Given the following financial information, calculate the missing values: $1,000 95,000 Cash Crop revenue Grain inventory Total operating expenses Prepaid expenses Notes payable Accrued interest Interest expense Supplies Owners' equity Machinery and equipment Farm real estate Total current assets Total current liabilities Accounts payable Cash investment in growing crops Net farm income Current portion of long-term debt Deferred portion of long-term debt $75,000 150,000 17,500 14,000 2,000 800 27,000 1,500 200 10,000 10,000 500 138,500
$ 145,600 Use the following information for Longliew Farms to answer problem 5. Crops & feed revenue Livestock and livestock product revenue Total nonfarm income Total farm operating expenses Depreciation expense Income tax expense Interest expense Withdrawals for family living Principal payments on unpaid operating debts Principal payments on current portions of debt & leases 215,300 12,000 252,629 50,526 10,827 64,962 28,000 29,890 a) Calculate capital replacement and term debt repayment capacity for LongView Farms. b) Calculate capital replacement and...
Fill in all of the boxes to complete the financial statements Balance Sheet/(cost basis) 2014 2015 2014 2015 Assets Current assets Cash Market Livestock Liabilities Current Liabilities Accounts Payable Cur. Port term debt 50,000 20,000 70,000 65,000 48,000 113,000 10,000 40,000 50,000 13,000 46,000 59,000 Total Current assets Total Cur. Liabilities Non-current Assets Machinery Building Land Total NC Assets Non-current Liabilities Mortgage Total NC Liabilities 380,000 380,000 334,000 334,000 350,000 130,000 550.000 1,030,000 310,000 95,000 550,000 955,000 Total Liabilities 430,000...
Below are the financial statements for Whistler Corporation: Whistler Corporation Financial Statements Balance Sheet: 2013 2014 Current Assets Cash $47,500 $76,700 Accounts Receivable $0 $43,100 Inventories $49,000 $36,500 Total current assets $96,500 $156,300 Noncurrent Assets Land $15,800 $15,800 Buildings $103,600 $164,600 Equipment $63,200 $65,500 Patent $5,200 $5,200 Accumulated depreciation -$10,800 -$12,200 Total noncurrent assets $177,000 $238,900 Total Assets $273,500 $395,200 Current Liabilities Accounts payable $48,000 $25,900 Income taxes payable ...