Please read all instructions
Need help with this assignment?Get an original answer from a qualified tutor — from $10/page.
Get it written →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).
Get a plagiarism-free answer to this question
Send us your instructions and we’ll match you with the best writer in your subject.
- 100% human-written, zero AI
- Turnitin report included
- Confidential — we never share your data
- Free revisions & refunds