Determine external financing need for exxonmobil

Assignment Help Accounting Basics

Reference no: EM132176430

Question - Prepare a financial forecasting report for ExxonMobil for 2018 (Please show work on Excel)

To simplify analysis, assume the following:

The firm (i.e., its assets) operates at full capacity.

Sales for 2018 are expected to grow as the same as rate as in the past, say from 2012 to 2017. Note: Please compute growth rate for XOM sales using past data, for example from 2012 to 2017.

About 50 percent of the operating expenses are variable.

All variable expenses are expected to vary at the same rate as sales. For example, if sales are expected to increase by 8 percent in 2018, variable expenses are also expected to increase by 8 percent in 2018.

Tax rate (taxes divided by taxable income or before tax income or earnings before taxes for 2017) will remain constant in 2018.

Interest expenses will remain constant (before financing decision is made) next year.

Dividend payments in 2018 will be the same as in 2017 (if any). Click on Cash Flow tab to determine Dividend Paid.

All current assets and long-term assets, notes, payables, and accruals will vary proportionately with projected sales for 2018.

Determine External Financing Need for ExxonMobil for 2018. That is, indicate how much fund your firm needs to raise from external sources in 2018.

Reference no: EM132176430

Questions Cloud

How an nhl team leaving town in the small market : Expand on your two team, fixed talent model with NBA teams to show how an NHL team leaving town in the small market will affect player salaries

Why this event is still personally significant : A conclusion that briefly implicitly or explicitly reviews your story, reiterates the lessons you learned and that you hope the reader to learn.

Reflect on your current and future practice : Describe your personal worldview, including the religious, spiritual, and cultural elements that you think most influence your personal philosophy of practice

What are the symptoms of major depressive disorder : What are the symptoms of Major Depressive Disorder? Why is it important to be able to recognize them? 250 word initial post.

Determine external financing need for exxonmobil : Determine External Financing Need for ExxonMobil for 2018. That is, indicate how much fund your firm needs to raise from external sources in 2018

Does technology help or harm security efforts : With the increasing use of technology in the workplace, determine if workplace security is getting easier or more difficult for organizations to manage.

How should society balance the need to treat individuals : How should society balance the need to treat individuals with ADHD using stimulants with public health concerns about the abuse of these same medications?

What are the features of the control implementation process : What are the features of the control implementation process? What should be considered when reviewing the effectiveness of a control measure?

Why has gore achieved such remarkable success : Starting sponsor-a sponsor who helps a new associate get started on his or her first job at Gore, or helps a present associate get started on a new job.

User Account

All Pages