Financial Analysis
Assumption Use in the Financial Plan
Additional Assumption in Sensitivity Analysis
FIRST TWELVE MONTH CASHFLOW RESULT
HOW MUCH SHOULD NORMAN PAY FOR THE EXCLUSIVE RIGHT?
FORECASTED CASHFLOW FOR THE NEXT FIVE-Year
CASH FLOW WITH A LOAN AT 8% PER ANNUM
SENSITIVITY ANALYSIS
THE SALES PRICE AND kg SALES GRADUALLY INCREASE AT 5%
THE SALES PRICE PER kg INCREASE AT 10% BUT THE UNIT SALES REMAIN AT 5%.
Investment Value Using At Discounted Rate 5%
Best Financial Plan and Option
Assumption Use In The Financial Plan
Additional Assumption in Sensitivity Analysis
It is further assumed that price will increase gradually at the rate of 8% per annum and sales will increase at 7% per annum.
For the purpose of analysis, both the sales price and Kg sales will gradually increase at 5%.
Another scenario will be that the sales price per Kg increase at 10% but the unit sales remain at 5%.
Best-case scenario assumption, Norman did not exercise his plan to borrow $100,000 at 8% per annum. We will look into what is the cash flow outlook if Norman did not exercise this option.
5. Norman believes that he could borrow up to $100,000 at 8% per annum. As an additional assumption, if Norman takes $100,000 loan, Norman will pay this loan for the first five years of the company operation. We will look into what is the cash flow outlook if Norman exercises this option.
6. We also assume that Norman will exercise the option to hire an assistant for $1,000 per month from the beginning of his online operation.
7. We also assume Norman will pay all payable tax in the year precedent to the year of tax payable.
8. We also assume that charges such as rental will remain constant throughout the period.
9. Norman plans to order from Belgium every two weeks 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 products to customers.
10. Exchange rate between Euros to U.S. dollar will remain at $1.355.
FIRST TWELVE MONTH CASHFLOW RESULT
The forecast cash flow for the first twelve month showed Norman can bring excess cash in after paying the tax.
HOW MUCH SHOULD NORMAN PAY FOR THE EXCLUSIVE RIGHT?
Based on these considerations
1. To maintain the maximum cash flow available to bring to the second year of operation and
2. after taking into consideration the amount of cash flow generated during the first year,
We suggest the amount of right payment to BelgChoc should be between $100,000 and $400,000. For the rest of the case study we assume Norman pays $100,000.
If Norman decides to pay $100,000 the excess cash for second year operation will be $309,073 but if he decides to pay $400,000 the…
Sample Source(s) Used
Bibliography
Saltelli, A., Ratto, M., Andres, T., Campolongo, F., Cariboni, J., Gatelli, D. Saisana, M., and Tarantola, S., 2008, Global Sensitivity Analysis.The Primer, John Wiley & Sons.
Sensitivity analysis. (2014). Retrieved Janaury30, 2014, from http://en.wikipedia.org/wiki/Sensitivity_analysis
Sheet1
€ Exchange Rate $
Related Documents
Study Document
Financial Statement Analysis
Financial statement analysis is a tool by which one can examine the publicly-available financial statements to determine the financial condition of a company. The role of the financial statements is to provide information for both internal and external stakeholders, including shareholders and regulators, about a company's finances. Thus, the SEC demands that financial statements are produced in a specific format so that there is easy comparison between companies and across
Study Document
Financial Ratio Analysis
Financial Ratio Analysis for Xerox Xerox Corporation is company in the field of technology and services, which is currently developing, manufacturing, marketing, and financing a whole range of document equipment, software, integrated solutions and services. They have a global network, with branches in more than 130 countries all over the world. In America, its products are distributed through divisions, subsidiaries and third-party distributors. In the rest of the world (Europe, Africa,
Study Document
Financial Management Fundamental Decisions in Financial Management...
Financial Management Fundamental Decisions in Financial Management In financial management, there are three fundamental decisions, which are central to capital budgeting, capital structure and working capital management. Capital budgeting refers to the process of planning and managing the company's long-term investments. Capital structure refers to the particular mixture of long-term debt and equity a company utilizes to fund its functions. Working capital management refers to the company's short-term assets, which may include
Study Document
Financial Management Differentiating Between the
The financial information these directors and managers require is often highly specific to their functional departments' goals and objectives. The director or senior manager of the operations and production departments will require variance analysis of costing, thorough analysis of supply chain costs and the cost of quality management and compliance management (Kivijarvi, Saarinen, 1995). These costs are critical to each of these directors ensuring a consistent level of conformance
Study Document
Financial Statement Analysis Project
Financial Statement Analysis The following is an equity research report on Starbucks. The company competes primarily in the quick service food industry, where it holds the #5 market share in the United States, and #1 in its segment of coffee (QSR Magazine, 2011). The company had revenues last fiscal year (ended 10/2/11) of $11.7 billion and net income of $1.245 billion. The current stock price is $43.91, which gives the company
Study Document
Financial Management Is an Important
(2009). Google's Big IPO, Five Years Later. [Article]. Wall Street Journal - Eastern Edition, 254(40), C3. Davis, H.Z., & Peles, Y.C. (1993). Measuring Equilibrating Forces of Financial Ratios. The Accounting Review, 68(4), 725-747. Google Inc. (2012). 2011 Annual Report. Mountain View, CA: Google Inc. Kirby, J. (2009). How Google really does it. (Cover story). [Article]. Canadian Business, 82(18), 54-58. Lee, M.-j. (2010). Measuring the Usage Effects of Tying a Messenger to Windows: A