MSIN0047 - Entrepreneurial Finance - Financial Model - Ratio Analysis - Assumptions - Profit & Loss - Cash Flow and Balance Sheet Statements Forecast - Finance Assignment Help

Assignment Task

Learning Outcomes:
This assignment contributes towards the achievement of the following stated module Learning Outcomes as highlighted below:
1. To learn the value and importance of a financial model. You can see how you can predict a possible future based on your assumptions. You can see what effect changing these assumptions has on the outcome.
2. To help you understand how the Assumptions, Profit & Loss, Cash Flow, and Balance Sheet statements are all interlinked. By changing one assumption, you can see the impact across all the statements.
3. It is an opportunity to put into practice what you have learned in class, e.g. creating your own ratios for the business.
4. If you are planning to start a business, this model is something of great practical use for you. You can take it away and adapt it in the future, making it more
sophisticated as you gain more information and experience.

Introduction:
Write some words of explanation describing what the business is about (i.e. its products and market). State clearly whether it is based on a real-life business or made up. Add any sources of reference/inspiration. This written information should be on the first tab.

Pricing Model & Sales Forecast:
The Pricing Model needs to be relevant to your business. As you change the prices you charge and the cost of the product, so it will affect the Sales Forecast and P&L.

Other Numerical Cost Assumptions:
You need to make changes to the other costs shown in the yellow boxes, which will drive the P&L. You can write some words of explanation against the input boxes if you wish.

Profit & Loss Forecast:
The model you have been given has one P&L which automatically calculates from the assumptions above. You can add some extra lines to the model, either fed from newly created assumptions or by creating some yellow boxes to input directly into the P&L.

Cash Flow Forecast:
Again, you have been given a simplistic cash flow model. Add some items to this (e.g. capital expenditure) to demonstrate your understanding of how this will interact with the Balance Sheet. Your Closing Bank Account must be positive both monthly and the consolidated value at the end of the year, otherwise you could fail this section. Add more debt, equity, or sales as appropriate to keep it positive.

Balance Sheet Forecast:
You need to add two items into the Fixed Assets and to depreciate them on a Straight Line or Reducing Balance basis. These assets can be anything you like (even a Ferrari!). These will also impact the P&L (through Depreciation) and the Cash Flow (when the item purchased initially). Consequently, this part of the exercise is a great learning experience.

Summary Page:
The model has a simple Summary page. This is so the reader of the spreadsheet can get the ‘big picture’ quickly. Adapt this to make it a more interesting ‘dashboard’ to see the ‘big picture’ of your business.

Ratios Analysis:
Complete the blank ratios in the model. Refer to the appendix on Ratios for the way to calculate them. Try and understand what they are telling you and add some comments.

Graphs:
The model contains 3 simple graphs. Create up to 7 graphs.

Design & Creativity:
Is your model visually clean, tidy and easy to use? Or is it a visual mess? Do you have some interesting technical features or is it just a ‘repainted’ version of the original model?

Questions:
Question. Can I use a different currency to £’s?
Question. I don’t have a business I want to start. What should I do?
Question. Can I make up the numbers that I have input?
Question. Does the business I choose have to be a ‘good idea’?
Question. Is it OK to use figures from a real-life company?
Question. Can I create a model from scratch and ignore the templates?
Question. Can I see previous examples of work?
Question. Can I use a previous student example as my starting template?
Question. Can I cut & paste from other models?
Question. My Excel skills are limited. What should I do?
Question. My business is an Internet start-up and has no stock. Does this matter?
Question. What is the difference between Carl’s Café and Davis Design Models?
Question. Why are your example templates (and class exercises) of ‘bricks & mortar’ types of businesses?
Question. Does everything need to be within the spreadsheet?
Question. What if my Balance Sheet won’t balance?

This Finance Assignment has been solved by our Finance experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.