Using the Microsoft Excel worksheet and the assumptions provided, project the 2017 expected net earnings for Meakin Farms and Meakin Industrial for each of Meakin's three options and calculate the combined results State all critical assumptions show excel functions 2016 2015 2014 3,200 3,840 2,480 acres acres acres Revenue Crop Revenue Canola 557,637 705,164 220,456 Wheat 158,068 341,946 526,282 Peas 107,572 87,245 109,976 823,277 1,134,355 856,714 Production Expenses Fertilizer, Seed, and Chemical 407,488 480,922 325,690 Gross Margin 415,789 653,433 531,024 Labour, Power, and Machinery Expenses Fuel, wages, insurance, and repairs 104,122 124,946 86,800 Amortization 87,133 101,053 74,732 Interest on equipment 40,321 52,679 35,789 Office, professional fees, etc 36,301 35,689 34,539 267,877 314,367 231,860 Contribution Margin 147,912 339,066 299,164 Land, Buildings, Land Finance Expenses Land rent 127,600 184,080 114,000 Interest on land 10,232 8,567 7,597 Amortization 5,360 4,505 1,278 143,192 197,152 122,875 Earnings from Operations 4,720 141,914 176,289 Income Taxes 1,180 35,479 44,072 Net Earnings 3,540 106,436 132,216 Revenue in 2015 was below expectations due to hail damage on 640 acres 2016 2015 2014 Revenue Bin Hauling 72,357 74,992 165,006 Grain Hauling 122,043 98,752 47,049 Seed, Fertilizer, and Chemical Hauling 75,459 56,543 33,056 269,859 230,287 245,111 Expenses Salaries, Wages, and Benefits 72,340 78,534 75,432 Fuel and Repairs 41,078 40,587 46,893 Equipment Leases 31,804 23,589 22,865 Amortization 44,851 34,662 32,800 Interest on Equipment 8,579 8,345 8,643 Insurance 21,338 20,549 21,065 Supplies, Office, and Other 8,533 8,465 7,449 228,523 214,731 215,147 Earnings from Operations 41,336 15,556 29,964 Provision for Income Taxes 10,334 3,889 7,491 Net Earnings 31,002 11,667 22,473

The Answer is in the image, click to view...

Answered step by step

Verified Expert Solution

Link Copied!

Question

1 Approved Answer

Posted on Mar 08, 2023

Using the Microsoft Excel worksheet and the assumptions provided, project the 2017 expected net earnings for Meakin Farms and Meakin Industrial for each of Meakin's

Using the Microsoft Excel worksheet and the assumptions provided, project the 2017 expected net earnings for Meakin Farms and Meakin Industrial for each of Meakin's three options and calculate the combined results. State all critical assumptions. show excel functions

			2016		2015	2014
			3,200		3,840	2,480
			acres		acres	acres
Revenue
	Crop Revenue
		Canola	557,637		705,164	220,456
		Wheat	158,068		341,946	526,282
		Peas	107,572		87,245	109,976
			823,277	*	1,134,355	856,714
Production Expenses
	Fertilizer, Seed, and Chemical		407,488		480,922	325,690
Gross Margin			415,789		653,433	531,024

Labour, Power, and Machinery Expenses
	Fuel, wages, insurance, and repairs		104,122		124,946	86,800
	Amortization		87,133		101,053	74,732
	Interest on equipment		40,321		52,679	35,789
	Office, professional fees, etc.		36,301		35,689	34,539
			267,877		314,367	231,860
Contribution Margin			147,912		339,066	299,164

Land, Buildings, Land Finance Expenses
	Land rent		127,600		184,080	114,000
	Interest on land		10,232		8,567	7,597
	Amortization		5,360		4,505	1,278
			143,192		197,152	122,875
Earnings from Operations			4,720		141,914	176,289
Income Taxes			1,180		35,479	44,072
Net Earnings			3,540		106,436	132,216

* Revenue in 2015 was below expectations due to hail damage on 640 acres.

		2016	2015	2014
Revenue
	Bin Hauling	72,357	74,992	165,006
	Grain Hauling	122,043	98,752	47,049
	Seed, Fertilizer, and Chemical Hauling	75,459	56,543	33,056
		269,859	230,287	245,111
Expenses
	Salaries, Wages, and Benefits	72,340	78,534	75,432
	Fuel and Repairs	41,078	40,587	46,893
	Equipment Leases	31,804	23,589	22,865
	Amortization	44,851	34,662	32,800
	Interest on Equipment	8,579	8,345	8,643
	Insurance	21,338	20,549	21,065
	Supplies, Office, and Other	8,533	8,465	7,449
		228,523	214,731	215,147

Earnings from Operations		41,336	15,556	29,964
Provision for Income Taxes		10,334	3,889	7,491
Net Earnings		31,002	11,667	22,473