Income Statement forecast for next three years for Walgreens along with a balance sheet forecast.
explain the Liquidity issues based off of quick ratio, current ratio, operating cash flow/ current liabilities, days in receivable for Account receivable, account payable turnover,working capital and days inventory turnover from walgreens latest financial statement.
Also look at the stage of life of walgreens are they paying dividends, purchasing treasuring, high debt, pay less in advertising or cash flow from operations is greater than net income.
When forecasting the income statement, please look into cost of goods sold, is it increasing due to material prices, sales cost, demand for product, variable or fix cost, gross margins
How does walgreens compare to its competitors
Financial leverage, coverage ratio
Change in earnings
Return on asset
Does the company have any solvency problems is the company profitable
Use you use chart but cite them
and lastly NOOOO professional analyis work can be used this is based off of personal analyis work

II. A description of the industry and how your firm competes within that industry.
(There are industry reports available through Armacost Library. Access described at the end of this document. Other sources can be used as well. Be sure to cite the sources that you use.)

A. Many of the larger companies participate in more than one industry, or have different segments with revenue from each industry. Develop and communicate your accurate understanding of the industry(ies) in which your firm competes.

B. Explain how the industry(ies) provide(s) value to customers.

C. Describe how the company achieves market share within its industry(ies). What is the firm’s strategy to beat the competition to supply value to customers/clients? How has this strategy paid off in terms of firm revenue relative to the revenue of competitors? How does the growth/decline of your firm’s revenue compare to that of competitors?

D. Are there disruptive shifts affecting the industry, such that future value creation for customers will have to be different from past value creation? Which changes are inevitable? Which changes are likely? How will the terms of competition be disrupted?

III. Analyze the Financial Statements and notes for clues about why your firm performed as it did in the past.

A. Reconfigure the comparative balance sheets and income statements into operating and non-operating (financing) sections. Provide an explanation for the categorization of any items that are not obvious. [For instance, sales and cost of goods sold are obviously operating; “Other” or “Investments” could require a decision on your part. I need to be able to see your thinking whenever your judgment has come into play.]

B. Assess profitability. What do the financial statements tell you about how the firm has achieved its gross margin? It’s profit margin? Have there been recent changes in profit margin? Why? Or why not?

C. Use the balance sheet in conjunction with the income statement (and of course, footnotes) to help you understand any changes in costs. Have there been shifts in the mix of fixed and variable costs? Can you see changes in the market cost of inputs over time? Did your firm just absorb these changes in costs, or did it do something to minimize the impact of higher costs or take advantage of lower costs?

D. Use the balance sheet and the statement of cash flows to understand how your firm has maintained or reconfigured its investments on long-term productive assets to adjust to changing factors of competition. Further, are there sources of value that your firm has developed through past expenditures that do not appear on the balance sheet? Will these sources of value require ongoing expenditures?

E. Evaluate the financing of the firm. In particular, evaluate return on equity using return on operating assets adjusted for leverage times spread. Does the firm have financial assets, and are these being used efficiently? Does the firm’s use of debt financing benefit equity providers? Is this benefit sustainable?

F. You will use your risk assessments later to adjust discount rates that you apply to forecasted earnings and cash flows. At this point, use financial statements and footnotes (Off-Balance Sheet Obligations) to assess risk. Does debt financing create an unsustainable level of solvency risk? Is liquidity a problem? Include scheduled cash payments that are only disclosed in the footnotes when you assess liquidity.

IV. Forecasting the income statement and the balance sheet

A. Develop specific sales forecasts for the next three fiscal years (2018, 2019, 2020), and a continuing (horizon) forecast for years 2021 and on. You should use industry and analyst reports in conjunction with your own insights. Cite your sources and explain the thought process you used to arrive at the forecast you will use.

B. Forecast operating income (expenses associated with your revenue forecasts). Use your discretion concerning the amount of detail that is useful and estimable. Clearly indicate your judgments regarding persistent and transitory income items. (Some expenses cannot be forecast until you have forecast net operating assets—e.g., depreciation.)

C. Forecast future net operating assets (operating assets less operating liabilities) necessary to support the sales forecasts. Use a level of details that allows you to include as much reliable information as is available to you, and stops short of just making stuff up. Use historic turnover ratios (Sales/_______) where you have reason to believe the ratio will continue at current levels, and adjust future turnover where you believe future assets levels needed to support sales will change. Remember to consider sources of value that do not appear on the firm’s balance sheet.

D. Forecast free cash flow, cash flow from operations less net cash used to invest in operating assets.

E. Forecast the financing of the firm. What will the firm do with free cash flow, or cover cash flow deficits? You will need to decide on future debt levels. Can or should the firm maintain its current financial leverage? What will be the future cash dividend/common share repurchase policy?


Sample Solution

Sample solution

Dante Alighieri played a critical role in the literature world through his poem Divine Comedy that was written in the 14th century. The poem contains Inferno, Purgatorio, and Paradiso. The Inferno is a description of the nine circles of torment that are found on the earth. It depicts the realms of the people that have gone against the spiritual values and who, instead, have chosen bestial appetite, violence, or fraud and malice. The nine circles of hell are limbo, lust, gluttony, greed and wrath. Others are heresy, violence, fraud, and treachery. The purpose of this paper is to examine the Dante’s Inferno in the perspective of its portrayal of God’s image and the justification of hell. 

In this epic poem, God is portrayed as a super being guilty of multiple weaknesses including being egotistic, unjust, and hypocritical. Dante, in this poem, depicts God as being more human than divine by challenging God’s omnipotence. Additionally, the manner in which Dante describes Hell is in full contradiction to the morals of God as written in the Bible. When god arranges Hell to flatter Himself, He commits egotism, a sin that is common among human beings (Cheney, 2016). The weakness is depicted in Limbo and on the Gate of Hell where, for instance, God sends those who do not worship Him to Hell. This implies that failure to worship Him is a sin.

God is also depicted as lacking justice in His actions thus removing the godly image. The injustice is portrayed by the manner in which the sodomites and opportunists are treated. The opportunists are subjected to banner chasing in their lives after death followed by being stung by insects and maggots. They are known to having done neither good nor bad during their lifetimes and, therefore, justice could have demanded that they be granted a neutral punishment having lived a neutral life. The sodomites are also punished unfairly by God when Brunetto Lattini is condemned to hell despite being a good leader (Babor, T. F., McGovern, T., & Robaina, K. (2017). While he commited sodomy, God chooses to ignore all the other good deeds that Brunetto did.

Finally, God is also portrayed as being hypocritical in His actions, a sin that further diminishes His godliness and makes Him more human. A case in point is when God condemns the sin of egotism and goes ahead to commit it repeatedly. Proverbs 29:23 states that “arrogance will bring your downfall, but if you are humble, you will be respected.” When Slattery condemns Dante’s human state as being weak, doubtful, and limited, he is proving God’s hypocrisy because He is also human (Verdicchio, 2015). The actions of God in Hell as portrayed by Dante are inconsistent with the Biblical literature. Both Dante and God are prone to making mistakes, something common among human beings thus making God more human.

To wrap it up, Dante portrays God is more human since He commits the same sins that humans commit: egotism, hypocrisy, and injustice. Hell is justified as being a destination for victims of the mistakes committed by God. The Hell is presented as being a totally different place as compared to what is written about it in the Bible. As a result, reading through the text gives an image of God who is prone to the very mistakes common to humans thus ripping Him off His lofty status of divine and, instead, making Him a mere human. Whether or not Dante did it intentionally is subject to debate but one thing is clear in the poem: the misconstrued notion of God is revealed to future generations.



Babor, T. F., McGovern, T., & Robaina, K. (2017). Dante’s inferno: Seven deadly sins in scientific publishing and how to avoid them. Addiction Science: A Guide for the Perplexed, 267.

Cheney, L. D. G. (2016). Illustrations for Dante’s Inferno: A Comparative Study of Sandro Botticelli, Giovanni Stradano, and Federico Zuccaro. Cultural and Religious Studies4(8), 487.

Verdicchio, M. (2015). Irony and Desire in Dante’s” Inferno” 27. Italica, 285-297.