Prepare a basic master budget, Corporate Finance

Assignment Help:

The first part requires you to prepare a basic master budget. The general description is provided in Part A, in this document. However the data for the assignment is to be obtained from the associated assignment data file. This file is in MS Excel format and requires you to enter your student number to generate the assignment data. The data generated is unique to each student. The basic format and requirements of the assignment are the same for each student, however the different data sets will result in a substantially different solution for each student.

The data file for this assignment is available on the Learnline site in the same section from where you obtained this document.

If you are unable to access this file in MS Excel format, then please contact the Lecturer who will provide you with a copy of the data in PDF format.

The second part requires you to write a brief report on the Cost Structures identified in the budget prepared for Part A and in the data provided in the data file for this assignment. The answer for this part will not be affected by the accuracy or otherwiseof your answer to Part A. The appropriateness (or otherwise) of this report will be based on the analysis you undertake using the data you produce in Part A and the additional calculations you provide for this part.

The third part also requires you to write a brief report on the Budgeted versus Actual Outcomes using the budget prepared for part A and the additional data provided in the data file for this assignment. The answer for this part will not be affected by the accuracy or otherwise of your answer to Part A. The appropriateness (or otherwise) of this report will be based on the analysis you undertake using the data you produce in Part A and the additional calculations you provide for this part.

The fourth part requires you to research a behavioural and communication issue related to budgeting and performance evaluation. You are required to refer to the outcomes of Part C to illustrate your essay/report. Details of the issue are provided in Part D. You are write a short essay or report, appropriately referenced. A short concise answer is all that is required.


Related Discussions:- Prepare a basic master budget

Evaluate the annualized forward premium, Question: (a) A bank quotes t...

Question: (a) A bank quotes the following prices for the US dollar: €0.7915 - €0.7918 A German company receives €10 million as payment for a generator supplied to an Americ

Growthg and assets, a firm wishes to maintain an internal growth rate of 6....

a firm wishes to maintain an internal growth rate of 6.5% and the dividend payout ratio of 25%. The current profit margin is 6%, and the firm uses no external financing sources. Wh

Discuss the importance of a trade unions recognition, "The Code of Practice...

"The Code of Practice set out in the fourth schedule to the Employment Relations Act shall- (a) provide practical guidance for the promotion of good employment relations". (Se

Rate of growth in a countrys national income, Problem: i) Consider the...

Problem: i) Consider the following apparently contradictory statements: a) ‘ an increase in the rate of growth in a country's national income relative to that in the rest

Types of fixed income securities, Question: i) Compare and contr...

Question: i) Compare and contrast the various types of fixed income securities. ii) ‘A new issue of callable bonds will generally carry a higher interest rate

Forecasting demand, The problem considered is that of forecasting demand fo...

The problem considered is that of forecasting demand for single-period products before the period starts. We study this problem for the case of a mail order apparel company that ne

Cash flow from an income statement, Describe how to build a cash flow from ...

Describe how to build a cash flow from an income statement.

New value of the equity, GeKay is now considering issuing $3 million in deb...

GeKay is now considering issuing $3 million in debt, and paying $150,000 yearly in interest at 5%, that it would keep rolling over "forever" (in perpetuity). The proceeds would

#title.finance., 3. Your firm has debt worth $200,000, with a yield of 9%, ...

3. Your firm has debt worth $200,000, with a yield of 9%, and equity worth $300,000. It is growing at a 5% rate, and its tax rate is 40%. A similar firm with no debt has a cost of

Net Working Capital, #questionSelecting Kanton Company''s Financing Strateg...

#questionSelecting Kanton Company''s Financing Strategy and Unsecured Short-Term Borrowing Arrangement. Morton Mercado, the CFO of Kanton Company, carefully developed the estimate

Write Your Message!

Captcha
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