“The Farm Winery” from the Harvard Business CoursePack.Case Study Assignment | Online Assignment

Read the case study, “The Farm Winery” from the Harvard Business CoursePack. Conduct your analysis using MS Excel and use MS Word to provide narrative. Be prepared to embed your spreadsheets into the Word document before submission. Madsen is particularly concerned that the business be self-sustaining in order to return capital to shareholders. Given this goal, address the following items: Articulate the goals and constraints of management in regards to their long-term objectives for the winery. Using the information in the balance sheet for December 31, 2013 (Exhibit 2) and the fiscal year 2014 budgets (Exhibits 3 and 4), prepare a projected balance sheet for The Farm Winery for fiscal year 2014. Based on the projections, can and should Madsen declare a dividend of $25,000 for fiscal year 2014, excluding the $80,000 investment in additional vineyard development? If he should not, does The Farm Winery require additional capital contributions in the first half of 2014? Based on your analysis, to what extent will Madsen achieve the financial goals he has for The Farm Winery in 2014, 2015, and beyond? Based on your analysis thus far, determine whether the winery should pursue the $80,000 investment in an additional vineyard development. Explain why or why not. What business steps should The Farm Winery modify or pursue to strengthen its financial position? Should the winery adjust its annual production volume? Cite your work in MLA format. In your narrative, minimize repeating what is already stated. Use facts and figures to support your position. Restating what is already covered in the case study does not create value. Present your spreadsheets in a properly formatted and readable style using formulas where applicable