国际商务管理 社会学心理学 信息和知识管理 管理类作业 经济学作业 法律作业 市场学作业 语言学作业金融作业格式 会计作业格式 物流管理作业
返回首页

Financial Modelling Instructions Exercise-金融模型练习作业写作需求

留学生金融学作业MGMT 1000 Financial Modelling Instructions

Purpose of the Exercise
Students will increase their understanding of several topic areas as a result of the “lab” exercise and subsequent discussion, including:

• Understanding of Financial Statements - students should have a better feel for balance sheets and income statements and how they are put together.
• Understanding of the DuPont Model - the exercise will reinforce the 4 profit variables as well as the impact of asset turnover on both profits and cash needs.
• Role of Industry Norms - in establishing benchmarks for performance.
• Appreciate the Need for Projections - as a tool for financial planning and strategy formulation.
• Appreciate Spreadsheeting Skills - as a tool for financial modeling in preparing business cases/plans.

The Exercise
Familiarize yourself with the website and associated multimedia exercises. Complete the following steps in moving the company to industry benchmarks:

Consultation Business

1. Income Statement - Look at the norms for the industry. Determine the impact of performing within industry norms by moving the company to industry norm for each of, expenses, client visits, billing per hour and direct cost per hour. How much has profit increased for the year as a result of this change? How much has the December bank loan declined as a result of the increase in profit.

2. Balance Sheet - Move the company to industry norms for each of accounts receivable days, inventory investment, fixed asset investment and accounts payable days. Calculate the decline in cash needs in December as a result of moving to the industry norms. (The amount the December bank loan declined.)

Retail Business

3. Income Statement - Look at the norms for the industry. Determine the impact of performing within industry norms by moving the company to industry norm for each of, gross margin, and expenses. How much has profit increased for the year as a result of this change. How much has the December bank loan declined as a result of the increase in profit.

4. Balance Sheet - Move the company to industry norms in the following categories: accounts receivable days, inventory turns, net fixed asset turnover and accounts payable days. Calculate the decline in cash needs in December as a result of moving to the industry norms. (The amount the December bank loan declined.)

The Report
Based on the experiences in the online exercise and from class discussions write a report (2 pages, 1,000 words max) that documents your understanding of the following:

1. The role of financial modeling as a planning tool.
2. The importance of an assumption sheet.
3. The value of industry standards and other bench marks in planning.
4. A personal statement on whether you would build your own financial model or would contract it out to an “expert”.
5. The role model building could play in the preparation of your project.



------分隔线----------------------------
UK Thesis Base Contacts

24小时在线客服

QQ:77276002

Email:77276002@qq.com

推荐内容