Question
Please use (SMA, TMA, EXS and regression) via excel on the given data below and help me in this and also provide proper explanations. Franchise
Please use (SMA, TMA, EXS and regression) via excel on the given data below and help me in this and also provide proper explanations.
Franchise taxes are levied on businesses that gain a franchise right of doing business in a jurisdiction's territory. The data in Table 9.1 are franchise tax revenues in the city of Sunbelt, Florida, from Year 1 to Year 9. During forecasting, you are informed that BellSouth's (the local telephone service provider) current franchise contract with the city ends in Year 11. The city will seek a 10 per cent franchise tax increase from the previous year's basis on BellSouth in Year 12. The franchise tax revenues from BellSouth during the last nine years are shown in Table 9.2. Forecast the franchise tax revenues of Years 10 to 12. Write short summary of your findings.
Table 9.1--Franchise Taxes in Sunbelt
Year | Revenues |
1 | $ 12,442,000.00 |
2 | $ 12,427,000.00 |
3 | $ 13,091,000.00 |
4 | $ 13,743,000.00 |
5 | $ 14,306,000.00 |
6 | $ 15,089,000.00 |
7 | $ 15,257,000.00 |
8 | $ 16,749,000.00 |
9 | $ 17,655,000.00 |
Table 9.2--Franchise Taxes from BellSouth in Sunbelt
Year | Revenues |
1 | $ 3,727,000.00 |
2 | $ 4,100,000.00 |
3 | $ 3,927,000.00 |
4 | $ 4,435,000.00 |
5 | $ 5,722,000.00 |
6 | $ 6,036,000.00 |
7 | $ 5,950,000.00 |
8 | $ 6,700,000.00 |
9 | $ 7,062,000.00 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started