Can you please show me how to add these calculations needed in Excel? Using formula. Show calculations as well, please. Attachments included.

Excel Required:

Attachments

DuPont Analysis, Forecasting with the Parsimonious Method and Estimating Share Value of Cisco Systems Inc Using the DCF Model Cisco Systems, Inc. is a multinational information technology company headquartered in San Jose, California, that produces and sells networking hardware, telecommunications equipment and other high-technology services. Cisco Systems was founded in December 1984 by Leonard Bosack and Sandy Lerner, two Stanford University computer scientists, who pioneered the concept of a local area network (LAN). In 1990, Cisco Systems went public with a market capitalization of \$224 million. By 2000, Cisco had become the most valuable company in the world with a more than $500 billion market capitalization. The stock was initially listed on the NASDAQ in 1990 , and then was added to the Dow Jones Industrial Average on June 8, 2009. Cisco is currently included in the S\&P 500 Index, the Russell 1000 Index, NASDAQ-100 Index and the Russell 1000 Growth Stock Index. 1 As Figure 1 shows, the stock price of Cisco Systems peaked in 1999-2000 before the burst of internet bubble. However, its stock price has been fluctuating in the range of $10$30 since 2001 . Following are the income statement and balance sheet for Cisco Systems for the year ended July 30, 2016 . Cisco Systems Inc. Consolidated Balance Sheets DuPont Analysis, Forecasting with the Parsimonious Method and Estimating Share Value of Cisco Systems Inc Using the DCF Model Cisco Systems, Inc. is a multinational information technology company headquartered in San Jose, California, that produces and sells networking hardware, telecommunications equipment and other high-technology services. Cisco Systems was founded in December 1984 by Leonard Bosack and Sandy Lerner, two Stanford University computer scientists, who pioneered the concept of a local area network (LAN). In 1990, Cisco Systems went public with a market capitalization of \$224 million. By 2000, Cisco had become the most valuable company in the world with a more than $500 billion market capitalization. The stock was initially listed on the NASDAQ in 1990 , and then was added to the Dow Jones Industrial Average on June 8, 2009. Cisco is currently included in the S\&P 500 Index, the Russell 1000 Index, NASDAQ-100 Index and the Russell 1000 Growth Stock Index. 1 As Figure 1 shows, the stock price of Cisco Systems peaked in 1999-2000 before the burst of internet bubble. However, its stock price has been fluctuating in the range of $10$30 since 2001 . Following are the income statement and balance sheet for Cisco Systems for the year ended July 30, 2016 . Cisco Systems Inc. Consolidated Balance Sheets