1

Dean Farmer recently won the lottery, and used his winnings to purchase a farm in 2018....

Question

Dean Farmer recently won the lottery, and used his winnings to purchase a farm in 2018....

Dean Farmer recently won the lottery, and used his winnings to purchase a farm in 2018. Dean did not go to college, but rather grew up on a farm, worked as a cabinet maker for 10 years, and then won the lottery. He was able to generate a beginning balance sheet, however he did not have experience with depreciation or market adjustments.

  1. Beginning Cost Basis Balance Sheet
  1. In addition to the original $75,000 operating loan at the beginning of the year, Dean took out an additional operating loan of $67,000 in July as a source of new financing for the year. Both loans are due on February 15, 2020.
  1. Dean also had records of his current account balances as of December 31, 2019

Cash

24,000

Interest payable

10,650

Fuel and oil expense

37,000

Interest paid

11,850

Property tax payable

16,000

Supplies on hand

18,000

Labor expense

18,000

Repair expense

36,900

Property taxes paid

15,000

Insurance expense

10,500

Accounts receivable

32,000

Feeder livestock purchases

20,000

Feed purchases

15,000

Crop sales (corn and wheat)

350,750

Corn Inventory

120,000

Principal paid-Beef Loan

10,000

Prepaid expenses

20,000

Principal paid-Farm Mortgage

20,000

Livestock sales

17,500

Government program payments

2,000

Crop expenses

220,000

Other livestock expenses

12,000

Market Livestock Inventory

36,000

Accounts Payable

17,000

Wheat Inventory

50,000

Feed on Hand

70,000

Create the Beginning Balance Sheet (Jan 1, 2019) in a new spreadsheet.

Answers

For Dean
Cost Basis Balance Sheet as at 1-1-2019
A Equity and Liabilities Amount ($)
1 Share capital (Balancing figure in Balance sheet) 617750
2 Non Current Liabilities
(i) Long Term Borrowings (given) 75000
3 Current Liabilities
(i) Accounts Payable 17000
(ii) Other Accrued Expenses (Note 2) 53500
Total 763250
B Assets
1 Non Current Assets
2 Current Assets
(i) Inventory (Note 3) 520750
(ii) Livestock (Note 4) 33500
(iii) Feed (Note 5) 55000
(iv) Supplies on hand 18000
(v) Accounts Receivable 32000
(vi) Cash (Note 1) 104000
Total 763250
Note 1: Cash workings
Closing balance of Cash (31-12-2019) 24000
Add Back: Expenses paid during the year
Fuel and oil expense 37000
Labor expense 18000
Property taxes paid 15000
Feed purchases 15000
Prepaid expenses 20000
Crop expenses 220000
Interest paid 11850
Repair expense 36900
Insurance expense 10500
Feeder livestock purchases 20000
Principal paid-Beef Loan 10000
Principal paid-Farm Mortgage 20000
Government program payments 2000
Other livestock expenses 12000
Less: Cash realised during the year
Livestock sales 17500
Crop sales (corn and wheat) 350750
Net Opening Cash Balance 104000
Note 2: Other Accrued Expenses
Particulars Closing Payable Paid Opening Payable
Property Tax 16000 15000 31000
Interest 10650 11850 22500
Total 53500
Note 3: Inventory
Closing Inventory:
Corn 120000
Wheat 50000
Total Closing Inventory 170000
Total Sales (Corn and Wheat) 350750
Therefore, Total Opening Inventory 520750
Note 4: Livestock
Total Closing Livestock Inventory 36000
Livestock Sales 17500
Feeder livestock purchases 20000
Therefore, Total Opening Livestock 33500
Note 5: Feed
Total Closing Feed on Hand 70000
Feed purchases 15000
Therefore, Total Opening Feed 55000


Similar Solved Questions

1 answers
A key difference between a replacement project analysis and an expansion project analysis is that the...
A key difference between a replacement project analysis and an expansion project analysis is that the net present value (NPV) technique that is used to evaluate capital budgeting projects should only be used to evaluate expansion projects, whereas either the NPV technique or the internal rate of ret...
1 answers
You are a local CPA hired by Dru Company as a consultant on financial reporting under...
You are a local CPA hired by Dru Company as a consultant on financial reporting under GAAP. Dru asks for your advice on the creditor's accounting for a troubled debt restructuring after (1) receipt of assets, (2) a modification of terms, or (3) a combination of the two. Write a memorandum explai...
1 answers
10. [-18.34 Points] DETAILS LARCALC11 4.5.032. Find the general solution of the differential equation. (Use C...
10. [-18.34 Points] DETAILS LARCALC11 4.5.032. Find the general solution of the differential equation. (Use C for the constant of integration.) dy 12x2 4 + x3 dx y = Submit Answer...
1 answers
Piechocki Corporation manufactures and sells a single product. The company uses units as the measure of...
Piechocki Corporation manufactures and sells a single product. The company uses units as the measure of activity in its budgets and performance reports. During May, the company budgeted for 6,300 units, but its actual level of activity was 6,250 units. The company has provided the following data con...
1 answers
A social scientist would like to analyze the relationship between educational attainment in years of higher...
A social scientist would like to analyze the relationship between educational attainment in years of higher education) and annual salary in $1,000s). He collects data on 20 individuals. A portion of the data is as follows: Salary Education Click here for the Excel Data File a. Find the sample regres...
1 answers
1 HAL produces two types of computers: PCs and VAXes. The computers are produced in two...
1 HAL produces two types of computers: PCs and VAXes. The computers are produced in two locations: New York and Los Angeles. New York can produce up to 800 computers and Los Angeles up to 1,000 computers. HAL can sell up to 900 PCs and 900 VAXes. The profit associated with each production site and c...
1 answers
Help!! with review questions !! DISCUSSION Transformer core characteristics can be observed by applying an AC...
Help!! with review questions !! DISCUSSION Transformer core characteristics can be observed by applying an AC excitation and observing signals representing flux density and field intensity on an oscilloscope. This is often referred to as a BH loop (B is the flux density and H is the magnetic field i...
1 answers
Consider the following information for questions 5-7: Standard Deviation Beta Security L Security M 25% 20%...
Consider the following information for questions 5-7: Standard Deviation Beta Security L Security M 25% 20% 99 1.12 Which Security has the most total risk? 5. Security L a. b. Security M Security L & Security M have the same total risk C. Which security should have the higher expected return? 6....
1 answers
High light only Ex. 3.2. Determine the values of x E R for which the following...
high light only Ex. 3.2. Determine the values of x E R for which the following series con- verge pointwise. n=0 η (2n+1) in Inn n=0 n=0 n=1 (0) Σαλαθι «Σανα) (0) Σαπουν (0 ΣΗ(el) (Σ. ...
1 answers
A $50,000 bond bearing interest at 5.5% payable semi-annually is redeemable at par on August 10,...
A $50,000 bond bearing interest at 5.5% payable semi-annually is redeemable at par on August 10, 2033. The bond is sold on the primary market on December 10, 2013, to yield 5% compounded semi-annually. Determine the amount of discount or premium on the sale of the bond....
1 answers
71. A solution of nitric acid has a density of 1.5 g/mL and is 20% by...
71. A solution of nitric acid has a density of 1.5 g/mL and is 20% by weight HNO3. a. What is the molarity of this solution of HNO;? b. What volume of this solution should be taken in order to prepare of 5.0 L of a solution of 0.15 M nitric acid by dilution with water? In order to obtain a precise c...
1 answers
Why might person earning $50,000 in annual income today [measured in 2011 Canadian dollars] be better...
Why might person earning $50,000 in annual income today [measured in 2011 Canadian dollars] be better off than a person earning $1,000,000 in annual income [measured in 2011 Canadian dollars] 100 years ago?...
1 answers
Question 1 include A, B & C I want to produce nitric acid, HNO3 using the...
Question 1 include A, B & C I want to produce nitric acid, HNO3 using the unbalanced reaction below. In the lab I have 250ml of a 0.50M solution of barium nitrate. Ba(NO3)2 + H2S →BaS + HNO3. A. Balance the reaction? B. How many moles of Barium nitrated do I have? C. How many moles of ...
1 answers
Use the NPV method to determine whether Stenback Products should invest in the following projects: ....
Use the NPV method to determine whether Stenback Products should invest in the following projects: . Pro oct A costs S265,000 and offers seven annual net cash inflows of S62.000 Stenback Products req nes . Project B costs S380,000 and offers ten annual net cash inflows of S7 1,000. Stenback anannual...
1 answers
Please Help. Identifications of Unknown Compound. I need help figuring this out. Please be detailed on...
Please Help. Identifications of Unknown Compound. I need help figuring this out. Please be detailed on why you think its correct Introduction One of the most important tasks that chemists are faced with is the separation and identification of compounds from mixtures. Gratifyingly, chemists have m...
1 answers
Alpine Luggage has a capacity to produce 410,000 suitcases per year. The company is currently producing...
Alpine Luggage has a capacity to produce 410,000 suitcases per year. The company is currently producing and selling 330,000 units per year at a selling price of $405 per case. The cost of producing and selling one case follows: Variable manufacturing costs $ 160 Fixed manufacturing cost...
1 answers
8. 0.54/1.11 points Previous Answers 1/6 Submissions Used My Notes The Turners have purchased a house...
8. 0.54/1.11 points Previous Answers 1/6 Submissions Used My Notes The Turners have purchased a house for $150,000. They made an initial down payment of $40,000 and secured a mortgage with interest charged at the rate of 7%/year compounded monthly on the unpaid balance. The loan is to be amortized o...
1 answers
The Seabury Corporation has a current ratio of 3.6 and an acid-test ratio of 2.4. The...
The Seabury Corporation has a current ratio of 3.6 and an acid-test ratio of 2.4. The corporation's current assets consist of cash. marketable securities, accounts receivable, and inventories. Inventory equals $84,000. Seabury Corporation's current liabilities must be: (Round your intermedia...
1 answers
(C8H18) or water (H2O)? Explain why 7) For each compound will it be more soluble in...
(C8H18) or water (H2O)? Explain why 7) For each compound will it be more soluble in octane a) benzene b) sodium bromide NaBr c) glucose ntane о-н...

-- 0.009552--