Prepare a financial analysis while he is away to help him

Assignment Help Financial Management
Reference no: EM132342456 , Length: 25

Financial Management Assignment -

Assessment - You have been asked by your 59 year old father-in-law Felix to help him assess a new venture. It is Friday night, and he needs the work finished by Sunday, in preparation for an early Monday morning meeting, so you know that he will not be able to give you any more information than he already has (and you will be unable to contact him over the weekend), and therefore you should rely on your own assumptions and estimates for some of the analysis if necessary.

Felix, who was educated in London, now lives in Zurich, Switzerland, and recently took early retirement (from a chocolate firm he joined 25 years ago), leaving the company with a lump sum (after tax) payment of CHF 900,000. Surprisingly, rather than being depressed by his new state of independence, he is excitedly contemplating a new career as a retailer of natural pearls. He is confident that he can set up a business to import pearls from Tahiti and sell them in Zurich. His wife, who he met at business school, is pleased with his passion for this possible new venture but concerned that it might turn into a financial disaster. She has suggested that he develop a financial plan to evaluate the venture and its viability.

After a couple of hours with Felix you have assembled the following information from him:

  • Orohena Pearls (owned by a business school roommate of Felix), an established supplier of Tahitian Pearls, located close to Pape'ete in Tahiti, is prepared to give him exclusive rights to sell their products in Switzerland for a six-year period in exchange for an upfront payment for those rights;
  • Single, undrilled, pearls sell in Tahiti for an average of 14,800 XPF each and Orohena Pearls (OP) is prepared to sell them to Felix at a 35% discount to this price (XPF is the international code for CFP francs the currency used in Tahiti and other parts of French Polynesia)
  • OP would ship to Felix on receipt of payment for each order;
  • Felix has found out that air freight (including insurance) from OP via courier would cost on average XPF 1,800 per pearl, and that the time from him placing an order to receiving the goods in Zurich would be three weeks (including the preparation and packing time in Tahiti); he would also have to pay the courier cost to OP on ordering;
  • Felix plans to order from OP monthly and intends to maintain a minimum stock of four weeks' worth of sales to ensure that he will be able to supply a suitable range of pearls to customers;
  • He will buy racking and a special safe at a total cost of CHF 5,700 to store the pearls, and has found a small commercial room nearby that he can rent for CHF 850 per month, payable monthly in advance, plus a security deposit of three month's rent (refundable in full if there is no damage to the premises);
  • He will also install an alarm system at an initial cost of CHF 5,500, plus a CHF 100 per month monitoring fee;
  • Felix will sell the pearls by internet only, and is planning to spend CHF 8,000 with a website designer to develop the site;
  • He has already spent CHF 9,000 on a market study that told him that once established, demand would be about 250 pearls per month, although in the first year sales would start at only 30 in the first month before building up slowly to the full level at the end of the first year, after which they would remain constant;
  • The above study assumed an average selling price in Switzerland of CHF 270 per pearl (ignore any impact of VAT/sales taxes in your calculations);
  • Packaging and shipping within Switzerland would average CHF 15 per pearl, and Felix is not currently intending to charge that to the customer;
  • All internet sales would be by credit card, with the credit card company taking 1.2% per sale and remitting the total monthly to Felix fifteen days after the end of each calendar month;
  • Felix believes that two students could run the operation part time at a total monthly cost to him (including employer's social charges) of CHF 3,600 each;
  • Felix believes that if necessary he could borrow up to an additional CHF 75,000 at 6% p.a.;
  • The effective overall marginal tax rate on income from a company set up to undertake this activity would be 40%, payable one year in arrears; Felix has also told you that he can invest any available cash at an after tax 4% per annum.

Felix also has a friend, Paula, who owns two jewellery shops in the Zurich area. Paula is interested in the venture and has agreed that if Felix can incorporate the pearls into pendants, she would give him a one year contract to purchase 30 pendants per month. She would pay Felix CHF 170 cash for each pendant (to be paid on delivery to Paula), and these sales would be in addition to the internet sales outlined above (and would start immediately). To do this Felix would need to purchase a small drill and jig (costing CHF 550) to hold the pearl while drilling, as well as silver chains and clasps at a cost of CHF 25 per set, plus CHF 7.50 for a presentation box for the pendant. He would also hire an assistant specifically to make and deliver the pendants at an additional cost of CHF 350 per month.

Felix remembers lectures on discounted cash flow analysis at business school (although he admits that he does not remember them well, unlike his wife who was a distinction student). He has asked you to prepare a financial analysis while he is away to help him with the decision, making clear any assumptions that you make; the analysis should not exceed 25 pages (everything included), and should include:

  • A summary of all assumptions and estimates that you have made for your analysis, including justifications where appropriate;
  • A break even analysis;
  • A Profit and Loss Statement for the first year of operations and Balance Sheet at the end of the first year;
  • Monthly cash flow for the first year of operation;
  • Annual cash flow for each further year;
  • A clear explanation, in plain English, of how much cash the venture will need to get started;
  • Any sensitivity analysis that you think would be helpful;
  • The most that Felix could offer OP as an upfront fee for the exclusive rights for the six year period (which does not include any pearl purchases) which would leave him no better or worse off than if he had not undertaken the venture, and the amount you suggest he should actually offer them;
  • Conclusions and recommendations;
  • A critical reflection of the method you have chosen to decide whether the venture is attractive or not, and what, if anything, you would do differently in any future financial analysis of this type, and why?

Felix has explained that he is going to be out of town for a wedding so will be unable to provide any assistance at all, but as he pointed out before leaving "you will find this easy with computers and the internet to help".

Your report should demonstrate skills of critical reflection, effective communication and balanced judgement; note that this is not a market report. Scripts that are excessively long (i.e. exceeding the page limit) will not be read beyond the point of the limit; there is no minimum word limit. Do not put your name on the paper.

The overall structure (within the 25 page limit as above) should be as follows:

1. Cover Page (1 page)

2. Table of Contents/List of Exhibits (1 page)

3. Executive Summary

4. Main Report

5. Critical Reflection

5. List of References.

The data in your answer should be clearly laid out in tabular format so that your approach and answer are both plainly evident.

Your report should demonstrate skills of critical reflection, effective communication and balanced judgement; note that this is not a market report. Scripts that are excessively long (i.e. exceeding the page limit) will not be read beyond the point of the limit; there is no minimum word limit. Do not put your name on the paper.

Reference no: EM132342456

Questions Cloud

Design construct that explicitly considers environmental : Green engineering is a design construct that explicitly considers environmental and sustainability factors within the design process.
Reflect on the analysis of the sin of suicide : How often do you engage with or witness death in your work? How has this experience or the lack of it shaped your view of death
What is the unemployment rate : Suppose that the US nonmilitary, noninstitutionalized adult population is 254 million, the number employed is 156 million, and the number employed is 8 million.
What do the four parts of the christian biblical narrative : How would you rank the importance of each of the four principles? How do you believe they would be ordered in the context of the Christian biblical narrative
Prepare a financial analysis while he is away to help him : UCBS7037 Financial Management Assignment - University of Cumbria, UK, Robert Kennedy College. Prepare a financial analysis while he is away to help him
What is your view of the analysis of disease : What aspects of the topic readings do you find the most interesting? What is your view of the analysis of disease and healing in the readings? Explain
Supply and demand other foreign countries : So if tourism increase in the US, how would this affect the supply and demand other foreign countries?
Biblical references that support position : To the Class: What is the Christian Worldview for what is the best approach if you encounter a shoplifter?
Greater or less in healthcare in the next ten years : With the role of the in mind government, do you think the role of government will be greater or less in healthcare in the next ten years?

Reviews

len2342456

7/20/2019 12:35:06 AM

Please note that this is a financial accounting management course assessment and hence need to show P&L, cash flow statements etc. He has asked you to prepare a financial analysis while he is away to help him with the decision, making clear any assumptions that you make; the analysis should not exceed 25 pages (everything included). The overall structure (within the 25 page limit as above) should be as follows: 1. Cover Page (1 page) 2. Table of Contents/List of Exhibits (1 page) 3. Executive Summary 4. Main Report 5. Critical Reflection 5. List of References. Just pasted the key elements of what is required out of this assignment.

len2342456

7/20/2019 12:34:58 AM

General Instructions - Please read carefully - You are required to complete the assessment outlined below and submit your completed final document through the RKC Online Campus by the end of Unit 6. Your grade will be based 100% on this final document, to which you will also receive written feedback. In addition you must upload part of the analysis for the above document by the end of Unit 3 (see Interim Assignment at the end of this document for more details). This draft will not be graded, but it is an important way of monitoring your progress, and you will receive feedback with respect to the topic covered in the interim assignment. Please ask any questions about the interim assignment or final assessment in the Forum. Note that this is a fictional case focused on understanding management accounting; you are not expected to comment in any way on aspects such as the market feasibility or the actual rates of tax in Switzerland.

len2342456

7/20/2019 12:34:52 AM

Submissions should be machine readable in MS-Word format only; submit only one file, and include any Excel analysis as images, not embedded files. Grading will be based on the following breakdown: Assumptions, estimates and sensitivity analysis: 25%, Cash flow and financial viability analysis: 25%, Other financial details (P&L Statement, Balance Sheet, break even, etc): 35%, Critical reflection: 10% and Referencing and presentation: 5%. The Interim Assignment is to develop the Profit and Loss Statement for the first year of operations, which you will see is also part of the required content of your final assessment paper. You should clearly explain any assumptions in this P&L Statement and you may, if you wish, make any changes to that P&L Statement for your subsequent Unit 6 final assessment submission. The Interim Assignment is not graded but you will receive feedback on it.

len2342456

7/20/2019 12:34:44 AM

Rubric - Assumptions, estimates and sensitivity analysis (20%) Excellent - wide range of key and peripheral assumptions, demonstrating critical evaluation and understanding of the issues. Cash flow and DCF analysis (25%) Excellent understanding of the theory and its application and subtleties. Other financial details (30%) Excellent understanding of the theory and its application and subtleties. Critical reflection (20%) Excellent understanding of the strengths and limitations of the required analysis, with clear ideas on areas of improvement. Referencing and presentation (5%) Excellent piece of writing, well-structured, coherent progression of argument, well-articulated and accurately referenced, with excellent summary and clear conclusions and recommendations.

Write a Review

 

Financial Management Questions & Answers

  You invest the money in stock with beta

If you invest the money in a stock with a beta of 1.75, what will be the required return on your $5.5 million portfolio?

  Buyer to purchase the underlying asset at the forward rate

A forward contract forces its buyer to purchase the underlying asset at the forward rate. In general, hedging with derivative contracts involves taking a position in the derivatives market that allows you to offset potential losses you might incur wi..

  Tangible and intangible costs related to late payments

Describe the tangible and intangible costs related to late payments.

  How would the PV and FV of above annuity change

How would the PV and FV of the above annuity change if it were an annuity due rather than an ordinary annuity?

  Explain the risk level compared to the overall market

What is the beta of this stock? How would you explain the risk level compared to the overall market?

  If the stable dollar assumption were dropped

Palomar Paper Products purchased land in 1996 for $15,000 cash. The company has held the land since that time. In 2014 Palomar purchased another tract of land for $15,000 cash. Explain how one could adjust the dollar amount reported in the land accou..

  What is the divisor on your index

At the end of the day, your index value is 5,718.80. What is the divisor on your index?

  Derive the put-call parity formula

A digital (k, t) call option gives its holder 1 at expiration time t if s(t)>=k or 0 if s(t) =k. Let C1 be the cost of the call. Let C2 be the cost of the put. Derive the put-call parity formula.

  Bid price represents broker buying price for security

The bid price represents the broker's buying price for a security. All primary market transactions must be registered with the SEC.

  Make hedging central american cattle

What suggestions would you propose (to the country, to the CME) to make hedging Central American cattle in the CME cattle contract?

  Find the payment amount for the loan

A loan has monthly payments. The APR is 19%, and interest is compounded 2 times per year. Calculate the effective interest rate that would be needed to find the payment amount for the loan.

  Savings for long term goals

Your long-term savings in 10% instead of 2% means a difference of hundreds of thousands of dollars more in your savings for long term goals.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd