Prepare a draft memo to the modern

Reference no: EM131517901 , Length: word count:1800

Problem -

You, CPA, work for Conrad Ltd. It is now May 12, 2015, and your boss, Marion Conrad, has just returned from meeting with a client and calls you into her office to review the work they require. "I have just met with George and Kelly of Modern Industries Ltd. (MIL)," Marion starts. "MIL manufactures and retails wooden picture frames. The company was incorporated in 1997 by George and was joined in 2007 by his daughter Kelly. George currently owns 70% of the company and Kelly owns 30%. George is looking forward to retiring soon and together he and Kelly have been formulating a plan for the redemption of his shares. George's shares are worth $4 million and he would like to redeem 50% of these within the next year, with the remainder redeemed in 3-5 years' time, depending on the company's cash flows." The draft financial statements of MIL are provided in Appendices I and II. "George has been looking at ways to finance the redemption. He has been in discussions with the bank as the company's line of credit is currently up for renewal. The bank has not yet seen the 2015 draft statements, but has been asking for them. Provided their financials are still in line with the industry, the bank has offered to renew the existing line of credit (with the same terms and conditions) or offer two new types of loans to replace the current line of credit facility. The line of credit does have a large amount of available credit, however, George dislikes the personal guarantees and is wondering about the value in the property, that is not reflected in the financial statements, being used as collateral in place of personal guarantees. The bank proposals, as well as an additional option George has provided information on, are included in Appendix III. "I have also reviewed the financial statements and gathered information on industry standards (Appendix IV)," Marion continues.

"As the bank will be looking to analyze MIL's financial situation, particularly in comparison to competitors, please prepare a vertical analysis and relevant ratio analysis for 2014 and 2015. You should include in your memo explanations and recommendations based on these analyses, supported by dollar values where possible. Additionally, if there are ways that MIL can improve their working capital management and their financial statements in general in order to improve their financing potential, this would be advantageous.

"Finally, I would also like you to analyze the current financing proposals. Be sure to consider the impact of each of these proposals on the financial statements and make a recommendation on which proposal to accept.

Please prepare a draft memo to the Modern with the results of your analysis."

Your response, not including Excel (if applicable), should not exceed 1,800 words.

Attachment:- Appendixes.rar

Reference no: EM131517901

Questions Cloud

Engage in backward vertical integration : To what extent does Apple engage in related diversification? To what extent do they engage in unrelated diversification?

Types of performance appraisal systems : Prepare a presentation that you, as an HR generalist, will give to the vice president of human resources and the companys owners recommending changes.

Was the use of the budget successful in achieving objective : What was the objective of the budget i.e., to motivate employees or control costs? Was the use of the budget successful in achieving the objective?

Determine the projected costs for utilities in given year : Determine the projected costs for utilities in year 5. The inflation rate has been determined to be 0.222 and the initial cost is $57.39.

Prepare a draft memo to the modern : Please prepare a draft memo to the Modern with the results of your analysis." Please prepare a vertical analysis and relevant ratio analysis for 2014 and 2015

Determine the annual budget for office utilities : Determine the annual budget for office utilities using the data from the past 12 months shown in Figure. Utility costs are expected to increase by 8%.

How much to produce and charge change : Does the method of deciding how much to produce and charge change when the market becomes a monopoly?

Which of the following is a feature of an endocrine gland : Some of the hormones produced by the anterior pituitary have an effect on other glands. Which of the following does not?

Prepare a comparison of the compensation : Prepare a comparison of the compensation and benefits costs that you will deliver to the company''s owners. Create at least chart to visually depict the most relevant data

User Account

All Pages