Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Franchise taxes are levied on businesses that gain a franchise right of doing business in a jurisdictions territory. The data in Table 9.1 are franchise

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 percent franchise tax increase from the previous year basis from 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 on your findings. You should be using all four forecasting techniques (SMA, TMA, EXS, and regression).

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

3.46 Rating (143 Votes )

There are 3 Steps involved in it

Step: 1

Data Franchise Taxes Year Sunbelt BellSouth in Sunbelt Revenues Revenues 1 1244200000 372700000 2 1242700000 410000000 3 1309100000 392700000 4 137430... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Document Format ( 1 attachment)

Excel file Icon
60e3feddc2b34_81308.xlsx

300 KBs Excel File

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Strategic Management A Competitive Advantage Approach Concepts

Authors: Fred R. David, Forest R. David

15th edition

978-0133444896, 133444791, 9780133444858, 133444899, 133444856, 978-0133444797

More Books

Students also viewed these Corporate Finance questions

Question

Describe how to distinguish needs from wants.

Answered: 1 week ago

Question

Do you think hostile takeovers are unethical? Why or why not?

Answered: 1 week ago

Question

=+d. What is the probability that x lies within .25 sec of 3?

Answered: 1 week ago

Question

=+b. Find the numerical value of k.

Answered: 1 week ago

Question

=+d. Find the standard deviation of the number of forms required.

Answered: 1 week ago