Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, I need an expert to help me urgently regarding this assignment question, please CAREFULLY READ THIS. This question, I am going to paste it
Hello, I need an expert to help me urgently regarding this assignment question, please CAREFULLY READ THIS. This question, I am going to paste it down below but this question has picturestables in the middle from UNDER QUESTION and ABOVE QUESTION
Since Chegg does not allow to upload multiple pictures, neither can I copy paste the images of the tables here as text, I have uploaded this one picture which has BOTH the tables needed to solve this question. I will now paste the entire question here and I hope you will understand that under Question and above question the tables are there in the picture I provided and you can see that the text in the picture matches the text I will write down here below. Hopefully an expert can solve this the CORRECT WAY as soon as possible!
HERE IS THE QUESTION!!
Budgeting and Management Reporting
The assignment is to be
handed in as one Excel spreadsheet and one pdf document.
Background
You have been employed as financial controller from of a small family
owned company. In the past there has really been no financial management but now that the founders daughter took over as CEO she wants proper procedures and reports. The company has a board of directors with three external board members plus two representatives of the owning family.
The company imports electronic equipment from South Korea and Japan and sells that to distributors.
There are no retail sales of the products directly to customers, but there is a service department selling spare parts online to consumers and repair shops. The company is organized into three divisions:
Audio salespersonsVideo salespersonand Spares salesperson
The purchasing is done by one person and you are in administration. The CEO is also a full time employee.
Business is going acceptably but there is a slight concern that the brands represented may not be at the spearhead of technology. The CEO is actively looking for new brands to sell, but that is likely to have an effect in earliest. Liquidity has been poor during the last year.
Numerical data
The income statement and balance sheet for and forecast can be found below. The company has prepared no operating budget nor any cash flow budgets in the past. NOW COMES THE TABLE, SEE PICTURE UNDER QUESTION IN PICTURE, SAME TEXT IN PICTURE.
The budget
Your first task is to prepare a master budgetoperating budget, balance sheet and cash flow budget for The budget may of course be partly based on the figures from previous years but all budget numbers and underlying assumptions must be briefly discussed and documented.
Where you lack data for the budget, carry out research and try to come up with sensible numbers that you can explain. Be sure to include recommendations and action points in the documentation, if you come up with any. NOW COMES THE TABLE, SEE THE PICTURE ABOVE QUESTION
The proposed financial report
Secondly, prepare a proposal for a financial report for the company, in particular the Board. Prepare a template a modelof the January monthly financial report,using January budget data, leaving the actual outcomes blank. Remember to include all relevant financial and non financial information, but without drowning the reader in details. The report must give the Board all necessary information for evaluating the performance of the company.
Grading notes
The assignment gives a maximum of points as follows:
documented budget assumptions with discussion and explanations p
a sensible and realistic operating budget p
a balance sheet that balances and ties in with the other parts p
a realistic monthly cash flow budget that ties in with the others p
reporting structure and template p
Please note that Excels that are incomprehensibleimpossible for me to understand will get no points! Late submissions will get points.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started