Excel work with forecasting specific periods

Get perfect grades by consistently using our writing services. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper

Please read all instructions

Open the file Verizon excel file, (I have also attached a word doc with notes to make it way easier for you to do)

Following the process outlined in the notes and slides, you have to forecast all items related to the following:

Sales

GOGS

SG&A

Working Capital (Receivables, Inventory, Payables, other current assets/liabilities)

Allowance for uncollectible accounts

PP&E and depreciation.

Intangibles

For your convenience, I have highlighted in light yellow the cells that you have to forecast.

IMPORTANT: Follow the process. Do NOT forecast each related cell separately. In other words, once you forecast gross margin, use that forecast to calculate COGS. Do not go and forecast COGS independently of your gross margin projections

I have formatted the cells as they are supposed to be. Blue cells are number inputs. Green cells means that this is a formula that links to another cell for your projections.

Where I have put a blue “1” it means that I want you to put whole numbers there (numbers that make sense obviously).

Got stuck with another paper? We can help! Use our paper writing service to score better grades and meet your deadlines.

Get 15% discount for your first order


Order a Similar Paper Order a Different Paper
Writerbay.net