BE314 Financial Modeling – Financial Planning & Analysis

Are you searching for the best solution on BE314 Financial Modelling Assessment? Then why don’t you visit our site? At Case Study Help, you will get 100% plagiarism free Assignment Writing Service from professional and skilled Writers. Students can contact to our Service executive at any time. Getting service from us is easy, and 100% safe also.

 

 

Assessment Details:-

• Course Code: BE314
• Course Title: Financial Modelling
• Referencing Styles: Harvard
• Words: 1000
• University: Singapore University of Social Sciences
• Country: SG

 

Assessment Task:-

 

1. Complete the empty cells in the Excel Output Table shown above. Clear working steps must be shown to receive marks. Note: # = 1 mark *=2 marks @= 3 marks.
2. Sketch a scatter plot for the regression equation.
3. Interpret the meaning of the slopes, β0and β1.
4. Tim intends to cut the ADSPENT budget by $5 million from the previous year. Explain what would happen to corporate sales.
5. Determine the covariance and correlation coefficient between the two variables. Advise Tim if he should use covariance as a means to understand the relationship between Sales and ADSPENT. Recommend alternative approach if necessary.
6. State the appropriate hypothesis statement and test for the significance of the coefficient of ADSPENT at α= 5% by using 2 different methods. Show and explain your steps.
7. Predict the sales if the ADSPENT is at $30,000,000.