Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with this project asap. Its due in 12 hours if anybody can help that would be amazing ARE 303 Assignment, Homework #
I need help with this project asap. Its due in 12 hours if anybody can help that would be amazing
ARE 303 Assignment, Homework # 3 Spring 2017 Analysis of Business Activities Due April 14, 2017 by 4:30pm in my office, Nelson Hall 3308 (you may turn it in early, too!) 100 points You will be graded on accuracy of the spread sheet as well as your discussion and arguments you might make in answering the questions below. Weighting of points will be 50/50. Strawberry Acres is experiencing some difficulty with understanding if the farm made a profit. They have asked you, a well known student, to help them analyze last year's performance from the annual totals of their income and expense accounts. They have also listed transactions regarding loans. Strawberry Acres principal product is pick-your-own and pre-picked strawberries, obviously. However, the farm also grows traditional products as well. The farm recently built a \"market\" where visitors can purchase fresh produce and other products. A fall festival is held in October with many \"farm entertaining activities\" a spring festival is also held, but to a much smaller scale. You will create a table in EXCEL similar to the one on MOODLE but with an annual (not monthly) column. This is similar to what we have seen in class. Be sure to keep your signs (+ or -) correct in the cash flow (left side or column). Place the correct entry in the proper place for your three activities of the business. Add a fourth activity for family living should you come across living expenses. Use this spreadsheet to gain insight into the farm situation. Other information you will need to complete this assignment: Beginning cash balance was $1,750 on January 1, 2016). Depreciation expense (both for tax and management purposes) was $27,800. Make sure that the cash flow, net total, balances with the net total of the four activities. From your analysis answer the following. What was total net cash flow? What was total net cash flow per activity: Operations/Production, Investing, Financing and Family Living? Briefly discuss the outcomes from each activity, (for example, did the farm borrow more than was paid back and implications if any) In your opinion, is the information provided sufficient and complete? What might be missing or in error? Does this make sense to you? Did Strawberry Acres make a profit this year? If the net of Investing is negative, what does this tell you about the future for Strawberry Acres? Or implications that exist for any business for that matter relative to this issue. Deposits for the period January 1, 2001 to December 31, 2001 PCA (operating loan) $65,000 Checkline Reserve (overdraft protection) 1,509 PCA Refund Stock (annual patronage based on usage) 335 1st Citizens (operating loan) 108,000 1st Citizens (irrigation equipment loan) 14,500 FSA Payments (government payments for program crops) 5,883 Incorrect deposit from FSA office 5,110 Wheat 6,973 Strawberries 253,421 Spring Hayrides 3,055 Lettuce 5,506 Vegetables Summer Stand 12,957 Wholesale Pumpkins 13,497 Retail Pumpkins 35,331 Market sales 5,531 Market kitchen sales 9,117 Fall Hayrides 27,028 Admissions to corn maze and \"back forty\" 20,867 Nibble Nook snack bar at \"back forty\" 6,359 Spring Hope festival 619 Interest income 65 24,065 Tobacco plants 9,000 Tobacco rent 33,306 Expenses: January 1, 2001 to December 31, 2001 Telephone Utilities 5,392 LP/Diesel/gas 14,947 Equipment Maintenance 22,136 Labor Fertilizer Chemical Seeds/Produce/Plants 46,782 Office expense 7,399 Insurance Supplies-parts 76,230 Farm Maintenance 13,309 Donations Advertising/Promotion (annual expenses) 11,353 Cash Labor Expansion expense of market building 11,438 Travel/Meeting expenses 10,677 Expenses continued FICA/Federal Tax Deposits $16,788 Subscriptions/Dues 305 Bank Charges 897 Legal/Accounting Licenses Land Rent $ 5,491 85,334 10,178 8,432 11,089 687 63,647 350 538 4,530 County Tax (property) 1,716 Employee loans 4,560 Capital Expenses Sales and Use tax Incorrect Deposit (to balance out) 5,110 Tobacco Rent (paid) 27,691 1st Citizens - Irrigation unit 3,945 25,557 836 principal interest 486 1st Citizens - Spade Plow 2,400 principal interest 620 1st Citizens - Production loan 105,000 principal interest 2,588 East Carolina Farm Credit 16,000 principal Interest 807 East Carolina Farm Credit 1,000 principal Interest 53 East Carolina Farm Credit 59,400 principal Interest 2,319 Case Credit (tractor and truck loan) 3,890 principal Interest 345 Case Credit (tractor #2) 4,500 principal Interest 106 Checkline Reserve 1,509 principal Interest 14 Personal Loan 5,000 principal Strawberry Acres Analysis of business activities for 2016 Beginning Cash $1,750.00 Cash Flow Description Income Operations Expenditure Revenue Investing Expenditure Revenue Financing Expenditure Family Living Revenue Expenditure Total Cash Flow Total Operating 0 0 Total Expense 0 Net Cash Pos $1,750.00 Net of Columns Check of Cash Flow Depreciation -27,800 Projected Operating Income -27,800 0 0 Total Revenue 0 Total Expend. Total Revenue 0 0 0 Total Expend. Total Revenue 0 0 0 Total Expend. 0 0Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started