PROJECT STEPS 1. Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
PROJECT STEPS 1. Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling spending data in preparation for a city bond offering for park funding. She wants to use Excel to create charts to illustrate some of her data and to apply a function to calculate the potential monthly and yearly costs to the city of different bond scenarios. 2. 3. Switch to the Spending worksheet. In the range E5:E10, add Conditional Formatting to show Solid Blue Data Bars. In the range F5:F10, add Line sparklines based on the data in the range B5:E10. Apply the Blue, Accent 1, Darker 25% (5th column, 5th row in the Theme Colors palette) sparkline color to the range F5:F10. Final Figure 1: Spending Worksheet 5 Cerver 6Fem-Foley $ 7 Oleander 11 Pestocene S Sartoris E 10 Total 12 16 IMG 37 IN A (130 40 Nam FOR cher Melinday E GARUMO C 6 Alanis Parks Department Spending on Parks, 2018-2021 M 172.331 S 225.200 SHUNKY 302.212 200.000 552638 S 1.452.567 $ WHOHING 178.000 $ 241 R$ 302.805 207,832 580 845 S 1.500.000 $ 180524 247.033 350.247 221,167 575230 1.534,311 Spending per Park 2018-2021 www.m WDER IS SANJAN 189.794 212,853 340800 237810 585 124 20 SUMM Decumentation Spending Projection bond Offering 13 Se 0 H 2018 Park Spending as Percentage of Total Caram 12% fartura DIN Pla 145 WI 2021 Park Spending as Percentage of Total 8.926 12% 15% SIN Olender SIN 0 Carn mremtide Concer masticate Flames Final Figure 2: Projection Worksheet 123 56789 10 11 12 13 14 15 87888497 16 17 18 19 20 21 22 A Spending per park B $700,000 $600,000 $500,000 $400,000 $300,000 5200,000 $100,000 C 2018 Carvoeit D E F G Alanis Parks Department Park Spending Projection Park Spending 2018-2021 Fern-Foley 2019 Dieander Documentation Spending Projection Bond Ciffering 2020 Pleistocene H 2021 Sartoris I J $1,600,000 $1,550,000 $1,500,000 $1,450,000 $1,400,000 $1,350,000 Total spending K 1 23 A 4 5 Total Bond Revenue 6 Quarterly Interest Rate # of payments 8 9 Quarterly Payments 10 Annual Payments 11 12 13 14 15 ($10,000.00) 16 17 ($20,000.00) 18 19 ($30,000.00) 20 ($40,000.00) 21 22 ($50,000.00) 23 ($60,000.00) ($70,000.00) 24 25 26 27 28 29 30 5.1 $0.00 B Alanis Parks Department Bond Offering Projection ($15,314.08 Option A ($61,256.31) $575,000 0.0169 60 ($15,314.08) ($61,256.31) C Quarterly Payments Option B $575,000 0.0175 60 Bond Offering Cost Comparison 2 ($15,555.68 ($15,799.25 117 ($62,222.73) D ($15,799.25) ($15,555.68) ($62,222.73) ($63,197.00) Annual Payments Option C $575,000 0.0181 60 Documentation Spending Projection Bond Offering ($63,197.00) (+) E PROJECT STEPS 1. Gudrun Duplessis is a manager in the Alanis Parks Department. Gudrun is compiling spending data in preparation for a city bond offering for park funding. She wants to use Excel to create charts to illustrate some of her data and to apply a function to calculate the potential monthly and yearly costs to the city of different bond scenarios. 2. 3. Switch to the Spending worksheet. In the range E5:E10, add Conditional Formatting to show Solid Blue Data Bars. In the range F5:F10, add Line sparklines based on the data in the range B5:E10. Apply the Blue, Accent 1, Darker 25% (5th column, 5th row in the Theme Colors palette) sparkline color to the range F5:F10. Final Figure 1: Spending Worksheet 5 Cerver 6Fem-Foley $ 7 Oleander 11 Pestocene S Sartoris E 10 Total 12 16 IMG 37 IN A (130 40 Nam FOR cher Melinday E GARUMO C 6 Alanis Parks Department Spending on Parks, 2018-2021 M 172.331 S 225.200 SHUNKY 302.212 200.000 552638 S 1.452.567 $ WHOHING 178.000 $ 241 R$ 302.805 207,832 580 845 S 1.500.000 $ 180524 247.033 350.247 221,167 575230 1.534,311 Spending per Park 2018-2021 www.m WDER IS SANJAN 189.794 212,853 340800 237810 585 124 20 SUMM Decumentation Spending Projection bond Offering 13 Se 0 H 2018 Park Spending as Percentage of Total Caram 12% fartura DIN Pla 145 WI 2021 Park Spending as Percentage of Total 8.926 12% 15% SIN Olender SIN 0 Carn mremtide Concer masticate Flames Final Figure 2: Projection Worksheet 123 56789 10 11 12 13 14 15 87888497 16 17 18 19 20 21 22 A Spending per park B $700,000 $600,000 $500,000 $400,000 $300,000 5200,000 $100,000 C 2018 Carvoeit D E F G Alanis Parks Department Park Spending Projection Park Spending 2018-2021 Fern-Foley 2019 Dieander Documentation Spending Projection Bond Ciffering 2020 Pleistocene H 2021 Sartoris I J $1,600,000 $1,550,000 $1,500,000 $1,450,000 $1,400,000 $1,350,000 Total spending K 1 23 A 4 5 Total Bond Revenue 6 Quarterly Interest Rate # of payments 8 9 Quarterly Payments 10 Annual Payments 11 12 13 14 15 ($10,000.00) 16 17 ($20,000.00) 18 19 ($30,000.00) 20 ($40,000.00) 21 22 ($50,000.00) 23 ($60,000.00) ($70,000.00) 24 25 26 27 28 29 30 5.1 $0.00 B Alanis Parks Department Bond Offering Projection ($15,314.08 Option A ($61,256.31) $575,000 0.0169 60 ($15,314.08) ($61,256.31) C Quarterly Payments Option B $575,000 0.0175 60 Bond Offering Cost Comparison 2 ($15,555.68 ($15,799.25 117 ($62,222.73) D ($15,799.25) ($15,555.68) ($62,222.73) ($63,197.00) Annual Payments Option C $575,000 0.0181 60 Documentation Spending Projection Bond Offering ($63,197.00) (+) E
Expert Answer:
Related Book For
Auditing and Assurance Services
ISBN: 978-0077862343
6th edition
Authors: Timothy Louwers, Robert Ramsay, David Sinason, Jerry Straws
Posted Date:
Students also viewed these programming questions
-
Melody Henderson has worked as a manager in the lawn service industry for 6 years. She is capable at recruiting and managing part-time workers. Her workers like her. Melody treats her customers well...
-
Bill Scott works as a manager in the Phoenix office of an international public accounting firm. His father has just taken a position as a purchasing agent for one of the public accounting firm's...
-
1). One of your friends is a manager in a Canada-wide retail chain. All the stores in Ontario have just become unionized, and your friend is not sure how to treat the staff. What advice would you...
-
The focal length of a thin biconvex lens is 20 cm. When an object is moved from a distance of 25 cm in m25 front of it to 50 cm, the magnification of its image changes from ms to m50. The ratio is m50
-
An independent consumer group tested radial tires from two major brands to determine whether there were any differences in the expected tread life. The data (in thousands of miles) are given here: a....
-
When the following compound is treated with Br 2 in the presence of a Lewis acid, one product predominates. Determine the structure of that product. Br FeBr3 ?
-
4. Reserve for encumbrance accounts in general fund balance sheets at year-end indicate: a The amount of net position required to complete the transaction(s) in the succeeding period b Noncompliance...
-
Neutron Stars and Super nova Remnants the Crab Nebula is a cloud of glowing gas about 10 light-years across, located about 6500 light years from the earth (Fig. 9.39). It is the remnant of a star...
-
What impacts do you think advertising has on customer demand and pricing of products?
-
Dr Jannie Chan Siew Lee is the founder of the Asia-Pacific-based watch retailer The Hour Glass. The business was created in 1979, and Jannie served as the company's managing director from...
-
Two attempts to guess the password have already been tried. Each of these words has a certain number of characters that have matched the correct password: O O worded73 56brownie johndrew98 Already...
-
Simplify. 32-6 3-6
-
1. (5 pts) Given y[n]= 2y[n-1] and y[0]=2, Write MATLAB code to calculate and plot y for 0
-
F ( t ) = t 4 + 1 8 t 2 + 8 1 2 , g ( t ) = ( t + 3 ) / 3 ; find ( f o g ) ( 9 )
-
How did they calculate allocated cost FLIGHT A FLIGHT 350 615 FLIGHT 3 1 Go GALS 20 G EXISTING SCHEME, DETERMINE THE OVE OR FLIGHTS A, B, AND C. 2 ED AT 7.00 PER K1.00 OF PILOT SALAF TOTAL NON-SALARY...
-
High Tech ManufacturingInc., incurred total indirect manufacturing labor costs of $540,000. The company is labor-intensive. Total labor hours during the period were 5,000. Using qualitativeanalysis,...
-
CASE 2 A comparative balance sheet for ABC Corporation is presented below: ABS CORPORATION Comparative Balance Sheet \ table [ [ , 2 0 2 2 ] , [ , , ] , [ Accounts receivable ( net ) , Assets, 6 0 ,...
-
Read Case Study Google: Dont Be Evil Unless and answer the following: Why do you think Google was adamant about not wanting to supply information requested by the government concerning the Child...
-
Crankwell Inc. is preparing its annual financial statements and annual report to stockholders. Management wants to be sure that all of the necessary and proper disclosures have been incorporated into...
-
If the entity is subject to the requirements of AS 5, what written representations should auditors obtain from the client with respect to internal control over financial reporting?
-
According to Rule 501, which of the following is not a discreditable act? a. Withholding a clients sales records. b. Failing to file or remit tax payments. c. Failing to follow requirements of the...
-
14. Assume in problem 12 that the city reports the work as a capital asset. Which ofthe following is true? a. Depreciation is not recorded because the city has no cost. b. Depreciation is not...
-
7. Which of the following is true for the Year 2 government-wide financial statements? a. Both expense and liability will be zero. b. Both expense and liability will be $110,000. c. Expense will be...
-
10. What liability should the city report on government-wide financial statements at the end ofYear 1? a. It depends on whether the employees work at governmental activities or business-type...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App