Highlights
Section A: Coursework Brief and Requirements
You need to produce a detailed financial model for your chosen business. Ideally, it should be a real business or project, but if you have not yet determined one, you can make one up. You have certain tasks, listed below, that you MUST do otherwise you will lose marks. You have been given the Davis Design and Carl’s Café financial models as template examples. You must take one of these as a starting point (Davis Design suggested), and then adapt and build upon it. By using these as a starting point, your final result will be a more advanced and useful functioning tool to take away at the end of the course. Note these spreadsheets have numerous hidden markers throughout which identify the individual term’s assignment. This has been done for plagiarism protection purposes and you should only use one of these two models for this reason. Neither of these models is perfect. They are not intended to be – they are merely demonstrations of what you can do, and inevitably do not cover every type of scenario. This gives you the opportunity to be creative and to adapt them to something more interesting. The basis of this assignment is to see how effectively you pick up this ‘tool’ and make it into something worthwhile and relevant for your chosen business and at the same time demonstrate what you have learned in the lectures. The exercise is also meant to be a fun way of learning about the statements by allowing you to be as creative as you wish.
To help you there are numerous chapters from my forthcoming Entrepreneurial Finance book. Chapter 4.5 deals specifically with building a financial model. Other chapters cover all the financial statements and an appendix shows how every ratio is calculated.
Section B: Module Learning Outcomes covered in this Assignment
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.
Section C: Additional Information from Module Leader
Backing Up Your Work Please make sure you make regular back-ups of your spreadsheet and save under a different name each day you work on it (I suggest adding the date each time). For example Davis Design Financial Model 4 Nov 19.xlsx You then can always fall back on an older copy, and you are clear which copy is which by the inclusion of the date. Do not ever rely on just one copy – otherwise, several days' work could be lost unnecessarily. Support Sessions Several support sessions will be arranged. These will involve the Teaching Assistants and/or myself sitting down with you on a one-to-one basis for 15-minute periods. You can attend more than one session. We will answer your questions and encourage you to try out different ideas to make your model more interesting. These sessions will be of most value if you have already started your assignment. Start Early A golden rule of this assignment is to start early on. Building a highly sophisticated or creative model takes a considerable amount of time. It is a great learning opportunity and up to you how far you want to take it in terms of sophistication. Submission Process Make sure you know the deadline date and put it in your diary now. Do not submit at the last minute. Any requests for extensions are subject to the UCL’s strict Extenuating Circumstances guidelines and are out of my personal control. File Size Your file size should not exceed 40MB, otherwise, Moodle will not allow uploading.
This should be more than adequate, but if necessary you can compress the file size (select File, Reduce File Size). Marking Feedback You will be given separate marks for each of the criteria shown with comments from a rubric (i.e. these are standard comments). Note the words under each criterion in the rubric should be seen as for guidance only. Marking may be influenced by other factors, such as your comprehension and technical creativity. The final mark is the definitive measure. There will also be some short additional comments. If you would like more detailed feedback, I am happy to sit down with you and discuss your individual work.
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. Can I add photos to my spreadsheet?
Question. Does everything need to be within the spreadsheet?
Question. Can I add comments?
Question.What if my Balance Sheet won’t balance?
Question. Can I use macros?
Question. Can I use another program other than Excel?
Question. Can you give me more help?
This BSBITU402: Property Finance and Development Assignment has been solved by our Finance and Development 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.
© Copyright 2026 My Uni Papers – Student Hustle Made Hassle Free. All rights reserved.