Chapter 3 Exercises

xlsx

School

Central Michigan University *

*We aren’t endorsed by this school

Course

580

Subject

Finance

Date

Jan 9, 2024

Type

xlsx

Pages

Uploaded by ElderRabbitPerson411

Create a line chart showing the growth in the annual CPI in the Excel file Consumer Price Index. Consumer Price Index - All Urban Consumers Year 2003 184.0 2004 188.9 2005 195.3 2006 201.6 2007 207.342 2008 215.303 2009 214.537 2010 218.056 2011 224.939 2012 229.594 Annual CPI 2003 2004 2005 2006 2007 0.0 50.0 100.0 150.0 200.0 250.0 Growth in Ann Yea Annual CPI

2008 2009 2010 2011 2012 nual CPI ar

A national homebuilder builds single-family homes and condominium-style townhouses. The Excel file House Sa on the selling price, lot cost, type of home, and region of the country (Midwest, South) for closings during one m Construct a scatter diagram showing the relationship between sales price and lot cost. What conclusion can you House Sales Region Type Selling Price Lot Cost Midwest Townhouse $85,145 $17,030 Midwest Townhouse $112,740 $20,700 Midwest Townhouse $115,350 $18,030 Midwest Townhouse $116,415 $19,600 Midwest Townhouse $133,070 $24,455 Midwest Single Family $136,530 $25,500 Midwest Townhouse $139,435 $29,155 Midwest Townhouse $139,955 $30,400 Midwest Townhouse $147,905 $24,650 Midwest Single Family $153,845 $27,500 Midwest Townhouse $155,270 $19,600 Midwest Townhouse $155,870 $24,650 As Lot cost increases, so does selling cost. South Single Family $160,000 $29,500 Midwest Single Family $165,220 $25,500 Midwest Single Family $165,350 $25,000 Midwest Single Family $168,354 $27,316 Midwest Single Family $168,500 $33,000 Midwest Single Family $170,000 $25,200 South Townhouse $172,749 $45,025 Midwest Single Family $175,000 $28,000 Midwest Townhouse $175,470 $28,600 Midwest Townhouse $179,365 $32,200 South Townhouse $181,916 $45,025 South Townhouse $182,237 $45,025 Midwest Single Family $183,370 $28,000 Midwest Single Family $184,210 $28,000 Midwest Single Family $184,460 $22,300 Midwest Townhouse $184,873 $33,400 Midwest Single Family $185,160 $29,000 South Single Family $186,000 $35,851 Midwest Townhouse $187,390 $27,000 Midwest Single Family $188,603 $31,300 Midwest Single Family $189,120 $35,000 South Single Family $191,028 $45,000 South Townhouse $196,898 $45,025 South Townhouse $198,202 $45,025 South Single Family $200,119 $45,000 $0 $100,000 $200,000 $300 $0 $10,000 $20,000 $30,000 $40,000 $50,000 $60,000 $70,000 $80,000 $90,000 $100,000 Relationship between S Se Lot Cost

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

South Townhouse $200,423 $45,025 Midwest Single Family $201,700 $40,940 South Single Family $202,000 $31,160 South Townhouse $203,076 $45,025 Midwest Single Family $203,950 $33,000 South Single Family $204,900 $34,000 South Single Family $205,821 $39,299 South Single Family $206,400 $35,851 South Single Family $207,345 $35,600 South Single Family $209,400 $43,579 Midwest Single Family $210,380 $33,856 Midwest Single Family $211,513 $31,300 South Single Family $211,797 $34,000 Midwest Townhouse $212,079 $33,400 South Single Family $214,205 $36,500 Midwest Single Family $214,900 $31,300 South Single Family $216,049 $35,600 South Single Family $219,990 $37,557 Midwest Single Family $220,257 $31,300 Midwest Single Family $223,890 $28,000 South Townhouse $224,108 $45,025 South Single Family $225,900 $28,618 South Single Family $226,000 $35,600 South Townhouse $230,000 $45,025 Midwest Single Family $230,440 $33,000 Midwest Single Family $230,555 $28,000 Midwest Single Family $233,900 $44,200 South Single Family $234,971 $29,202 South Single Family $239,000 $39,169 South Single Family $239,870 $41,354 South Single Family $241,195 $41,340 South Single Family $242,191 $33,434 South Single Family $242,899 $48,252 South Single Family $246,648 $41,600 Midwest Single Family $248,500 $20,000 South Single Family $249,900 $38,200 Midwest Single Family $250,005 $33,000 South Townhouse $250,800 $73,400 South Single Family $252,135 $41,341 South Single Family $253,055 $41,340 South Single Family $254,048 $39,680 South Single Family $255,000 $43,198 South Single Family $256,235 $48,500 South Single Family $257,040 $37,631

South Townhouse $260,100 $73,400 Midwest Single Family $262,740 $44,900 South Single Family $262,890 $48,500 South Single Family $265,058 $41,404 Midwest Townhouse $265,500 $35,800 South Townhouse $267,060 $73,400 South Single Family $267,250 $45,676 South Townhouse $267,640 $73,400 South Single Family $268,000 $43,344 Midwest Single Family $268,210 $29,700 South Single Family $268,500 $41,099 South Townhouse $269,410 $73,400 South Single Family $270,518 $46,499 Midwest Single Family $271,105 $45,000 Midwest Single Family $274,455 $41,000 South Single Family $274,903 $45,345 Midwest Single Family $277,720 $44,650 South Single Family $280,622 $45,130 South Single Family $280,804 $40,667 Midwest Single Family $281,487 $57,285 South Single Family $281,824 $50,448 Midwest Single Family $283,440 $50,900 South Single Family $286,758 $57,000 South Single Family $287,771 $46,300 Midwest Single Family $289,000 $44,000 South Single Family $290,000 $48,300 South Single Family $290,190 $82,250 South Townhouse $294,450 $73,400 South Single Family $294,990 $57,000 South Single Family $299,096 $43,784 South Single Family $301,500 $59,000 South Single Family $305,000 $49,067 Midwest Single Family $307,373 $41,292 South Single Family $307,387 $45,850 South Single Family $307,663 $44,840 South Single Family $309,075 $82,250 South Single Family $310,100 $41,800 South Single Family $310,372 $60,000 South Single Family $312,898 $40,768 South Single Family $318,274 $85,800 South Single Family $318,523 $50,000 South Single Family $319,602 $82,250 South Single Family $322,920 $82,250 Midwest Single Family $323,716 $34,500

South Single Family $324,266 $47,891 South Single Family $324,412 $62,523 South Single Family $326,570 $51,000 South Single Family $329,611 $48,611 Midwest Single Family $330,486 $35,000 South Single Family $330,710 $49,920 South Single Family $333,158 $49,123 South Townhouse $335,000 $68,375 South Single Family $337,374 $70,399 South Single Family $337,380 $49,150 South Single Family $338,065 $54,850 South Single Family $340,000 $40,000 South Single Family $340,730 $50,850 South Single Family $342,423 $48,309 Midwest Single Family $348,744 $53,000 South Single Family $350,702 $46,386 South Single Family $352,781 $60,000 South Single Family $354,065 $48,115 South Single Family $354,117 $56,219 South Single Family $355,688 $65,373 South Single Family $358,162 $44,470 South Single Family $359,949 $50,591 South Single Family $366,990 $55,508 South Single Family $367,600 $50,000 South Single Family $369,101 $46,773 South Single Family $371,152 $58,223 South Single Family $379,000 $72,915 South Single Family $379,424 $64,902 South Single Family $379,575 $44,294 South Single Family $385,000 $75,000 South Single Family $385,942 $49,123 South Single Family $387,527 $48,000 South Single Family $398,651 $65,429 South Single Family $400,330 $75,510 South Single Family $404,510 $58,225 South Single Family $407,076 $48,668 Midwest Single Family $410,810 $66,500 South Single Family $417,790 $63,099 South Single Family $432,426 $57,422 South Single Family $444,304 $53,938 South Single Family $446,507 $75,510 South Single Family $492,820 $84,122 South Single Family $575,120 $79,790

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

ales provides information month u reach? 0,000 $400,000 $500,000 $600,000 $700,000 Selling Price and Lot Cost elling Price

Create a bubble chart for the first five colleges in the Excel file Colleges and Universities for which the x-axis is the , y-axis is acceptance rate, and bubbles represent the expenditures per student. Colleges and Universities School Type Median Acceptance Rate Expenditures/Student Top 10% HS Graduati Amherst Lib Arts 1315 22% $ 26,636 85 93 Barnard Lib Arts 1220 53% $ 17,653 69 80 Bates Lib Arts 1240 36% $ 17,554 58 88 BerkeleyUniversit 1176 37% $ 23,665 95 68 Bowdoin Lib Arts 1300 24% $ 25,703 78 90 Brown Universit 1281 24% $ 24,201 80 90 Bryn MawLib Arts 1255 56% $ 18,847 70 84 Cal TechUniversit 1400 31% $ 102,262 98 75 Carleton Lib Arts 1300 40% $ 15,904 75 80 CarnegieUniversit 1225 64% $ 33,607 52 77 ClaremonLib Arts 1260 36% $ 20,377 68 74 Colby Lib Arts 1200 46% $ 18,872 52 84 Colgate Lib Arts 1258 38% $ 17,520 61 85 ColumbiaUniversit 1268 29% $ 45,879 78 90 Cornell Universit 1280 30% $ 37,137 85 83 DavisdsoLib Arts 1230 36% $ 17,721 77 89 Duke Universit 1310 25% $ 39,504 91 91 GeorgetoUniversit 1278 24% $ 23,115 79 89 Grinnell Lib Arts 1244 67% $ 22,301 65 73 HamiltonLib Arts 1215 38% $ 20,722 51 85 Harvard Universit 1370 18% $ 46,918 90 90 Haverfor Lib Arts 1285 35% $ 19,418 71 87 Johns HoUniversit 1290 48% $ 45,460 69 86 MiddlebuLib Arts 1255 25% $ 24,718 65 92 MIT Universit 1357 30% $ 56,766 95 86 Mount HoLib Arts 1200 61% $ 23,358 47 83 NorthwesUniversit 1230 47% $ 28,851 77 82 Oberlin Lib Arts 1247 54% $ 23,591 64 77 Occident Lib Arts 1170 49% $ 20,192 54 72 Pomona Lib Arts 1320 33% $ 26,668 79 80 PrincetonUniversit 1340 17% $ 48,123 89 93 Rice Universit 1327 24% $ 26,730 85 88 Smith Lib Arts 1195 57% $ 25,271 65 87 Stanford Universit 1370 18% $ 61,921 92 88 SwarthnoLib Arts 1310 24% $ 27,487 78 88 U MichigUniversit 1195 60% $ 21,853 71 77 U of Chi Universit 1300 45% $ 38,937 74 73 U of RochUniversit 1155 56% $ 38,597 52 73

U PennsyUniversit 1280 41% $ 30,882 87 86 U Va Universit 1218 37% $ 19,365 77 88 UCLA Universit 1142 43% $ 26,859 96 61 UNC Universit 1109 32% $ 19,684 82 73 Vassar Lib Arts 1287 43% $ 20,179 53 84 WashingtUniversit 1225 54% $ 39,883 71 76 WashintoLib Arts 1234 29% $ 17,998 61 78 WellesleyLib Arts 1250 49% $ 27,879 76 86 WesleyanLib Arts 1290 35% $ 19,948 73 91 Williams Lib Arts 1336 28% $ 23,772 86 93 Yale Universit 1350 19% $ 52,468 90 93

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

e top 10% HS Expenditures/Student 26636 17653 17554 23665 25703 24201 18847 102262 15904 33607 20377 18872 17520 45879 37137 17721 39504 23115 22301 20722 46918 19418 45460 24718 56766 23358 28851 23591 20192 26668 48123 26730 25271 61921 27487 21853 38937 38597 55 60 65 70 75 80 85 90 95 100 0 10 20 30 40 50 60 70 80 90 100 Colleges and Universities- Student Expenditures Top 10% HS Graduation Rate

30882 19365 26859 19684 20179 39883 17998 27879 19948 23772 52468

Apply three different colors of data bars to lunch, dinner, and delivery sales in the Excel file Restaurant Sa Then sort the data by the day of the week beginning on Sunday. Compare the nonsorted data with the so Restaurant Sales Date Lunch Sales $ Dinner Sales $ Delivery Sales $ Date 1-Apr $873.00 $1,345.00 $489.00 31-Mar 8-Apr $697.00 $1,209.00 $341.00 1-Apr 15-Apr $741.00 $1,137.00 $326.00 3-Apr 22-Apr $846.00 $1,324.00 $319.00 4-Apr 29-Apr $779.00 $1,229.00 $398.00 5-Apr 3-Apr $289.00 $646.00 $321.00 6-Apr 10-Apr $307.00 $579.00 $328.00 7-Apr 17-Apr $298.00 $572.00 $365.00 8-Apr 24-Apr $233.00 $523.00 $411.00 10-Apr 4-Apr $354.00 $782.00 $289.00 11-Apr 11-Apr $387.00 $664.00 $301.00 12-Apr 18-Apr $419.00 $621.00 $278.00 13-Apr 25-Apr $341.00 $731.00 $243.00 14-Apr 5-Apr $403.00 $805.00 $276.00 15-Apr 12-Apr $412.00 $891.00 $243.00 17-Apr 19-Apr $345.00 $913.00 $294.00 18-Apr 26-Apr $426.00 $940.00 $350.00 19-Apr 6-Apr $442.00 $1,289.00 $1,242.00 20-Apr 13-Apr $508.00 $1,178.00 $1,068.00 21-Apr 20-Apr $467.00 $1,332.00 $1,254.00 22-Apr 27-Apr $379.00 $1,409.00 $1,143.00 24-Apr 31-Mar $542.00 $1,468.00 $884.00 25-Apr 7-Apr $449.00 $1,652.00 $782.00 26-Apr 14-Apr $503.00 $1,581.00 $714.00 27-Apr 21-Apr $622.00 $1,732.00 $636.00 28-Apr 28-Apr $592.00 $1,856.00 $601.00 29-Apr Sorted: Unsorted: $2 $4 $6 $8 $1,0 $1,2 $1,4 $1,6 $1,8 $2,0 Daily Sales in USD $200.00 $400.00 $600.00 $800.00 $1,000.00 $1,200.00 $1,400.00 $1,600.00 $1,800.00 $2,000.00 Daily Lunch, Dinner and Delivery Sales Daily Sales in USD

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

31-Mar 7-Apr 14-Apr 21-Apr 28-Apr $0.00 $200.00 Lunch Dinner Delivery Date

ales to visualize the relative amounts of sales orted data and comment on the information content of the visualizations. Lunch Sales $ Dinner Sales $ Delivery Sales $ $542.00 $1,468.00 $884.00 $873.00 $1,345.00 $489.00 $289.00 $646.00 $321.00 $354.00 $782.00 $289.00 $403.00 $805.00 $276.00 $442.00 $1,289.00 $1,242.00 $449.00 $1,652.00 $782.00 $697.00 $1,209.00 $341.00 $307.00 $579.00 $328.00 $387.00 $664.00 $301.00 $412.00 $891.00 $243.00 $508.00 $1,178.00 $1,068.00 $503.00 $1,581.00 $714.00 $741.00 $1,137.00 $326.00 $298.00 $572.00 $365.00 $419.00 $621.00 $278.00 $345.00 $913.00 $294.00 $467.00 $1,332.00 $1,254.00 $622.00 $1,732.00 $636.00 $846.00 $1,324.00 $319.00 $233.00 $523.00 $411.00 $341.00 $731.00 $243.00 $426.00 $940.00 $350.00 $379.00 $1,409.00 $1,143.00 $592.00 $1,856.00 $601.00 $779.00 $1,229.00 $398.00 $0.00 200.00 400.00 600.00 800.00 000.00 200.00 400.00 600.00 800.00 000.00 Daily Lunch, Dinner and Delivery Sales

31-Mar 7-Apr 14-Apr 21-Apr 28-Apr $0.00 Lunch Dinner Delivery Date

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Create a treemap for the regions, items, and units sold in the Excel file Store and Regional Sales Database. Store and Regional Sales Database ID Store No. Sales Region Item Description Units Sold Week Ending 1 1 South 24" Monitor 28 October 2 1 South 24" Monitor 30 November 3 1 South 24" Monitor 9 December 4 1 South 30 October 5 1 South 35 November 6 1 South 39 December 7 1 South PC Mouse 28 October 8 1 South PC Mouse 3 November 9 1 South PC Mouse 38 December 10 1 South Laptop 25 October 11 1 South Laptop 27 November 12 1 South Laptop 33 December 13 2 South 24" Monitor 8 October 14 2 South 24" Monitor 8 November 15 2 South 24" Monitor 10 December Wireless Keyboard Wireless Keyboard Wireless Keyboard

16 2 South 8 October 17 2 South 8 November 18 2 South 8 December 19 2 South PC Mouse 9 October 20 2 South PC Mouse 9 November 21 2 South PC Mouse 8 December 22 2 South Laptop 18 October 23 2 South Laptop 18 November 24 2 South Laptop 20 December 25 3 South 24" Monitor 38 October 26 3 South 24" Monitor 30 November 27 3 South 24" Monitor 3 December 28 3 South 30 October 29 3 South 32 November 30 3 South 33 December 31 3 South PC Mouse 25 October Wireless Keyboard Wireless Keyboard Wireless Keyboard Wireless Keyboard Wireless Keyboard Wireless Keyboard

32 3 South PC Mouse 5 November 33 3 South PC Mouse 26 December 34 3 South Laptop 28 October 35 3 South Laptop 27 November 36 3 South Laptop 29 December 37 4 North 24" Monitor 18 October 38 4 North 24" Monitor 20 November 39 4 North 24" Monitor 4 December 40 4 North 12 October 41 4 North 24 November 42 4 North 36 December 43 4 North PC Mouse 29 October 44 4 North PC Mouse 11 November 45 4 North PC Mouse 38 December 46 4 North Laptop 21 October 47 4 North Laptop 24 November 48 4 North Laptop 30 December 49 5 North 24" Monitor 27 October 50 5 North 24" Monitor 25 November Wireless Keyboard Wireless Keyboard Wireless Keyboard

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

51 5 North 24" Monitor 23 December 52 5 North 80 October 53 5 North 82 November 54 5 North 75 December 55 5 North PC Mouse 65 October 56 5 North PC Mouse 24 November 57 5 North PC Mouse 55 December 58 5 North Laptop 55 October 59 5 North Laptop 57 November 60 5 North Laptop 47 December 61 6 East 24" Monitor 24 October 62 6 East 24" Monitor 85 November 63 6 East 24" Monitor 56 December 64 6 East 52 October 65 6 East 58 November 66 6 East 69 December Wireless Keyboard Wireless Keyboard Wireless Keyboard Wireless Keyboard Wireless Keyboard Wireless Keyboard

67 6 East PC Mouse 35 October 68 6 East PC Mouse 39 November 69 6 East PC Mouse 44 December 70 6 East Laptop 78 October 71 6 East Laptop 88 November 72 6 East Laptop 99 December 73 7 East 24" Monitor 34 October 74 7 East 24" Monitor 36 November 75 7 East 24" Monitor 35 December 76 7 East 49 October 77 7 East 47 November 78 7 East 48 December 79 7 East PC Mouse 45 October 80 7 East PC Mouse 42 November 81 7 East PC Mouse 45 December 82 7 East Laptop 55 October 83 7 East Laptop 57 November 84 7 East Laptop 55 December 85 8 East 24" Monitor 18 October Wireless Keyboard Wireless Keyboard Wireless Keyboard

86 8 East 24" Monitor 17 November 87 8 East 24" Monitor 23 December 88 8 East 22 October 89 8 East 18 November 90 8 East 22 December 91 8 East PC Mouse 14 October 92 8 East PC Mouse 16 November 93 8 East PC Mouse 17 December 94 8 East Laptop 32 October 95 8 East Laptop 28 November 96 8 East Laptop 30 December Wireless Keyboard Wireless Keyboard Wireless Keyboard

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

This chart isn't available in your version of Excel. Editing this shape or saving this workbook into a different file format will permanently break the chart.

Your preview ends here

Eager to read complete document? Join bartleby learn and gain access to the full version

Access to all documents
Unlimited textbook solutions
24/7 expert homework help

Related Documents

Written ROE Exam 1 William Boswell 2.docx

Written ROE Exam 1 William Boswell.docx

Stock and Bond Investments - Chapter 13 Assignment - Part 1.docx

Matthew Kvilvang FINE 418 Module 4 Assignment.docx

Matthew Kvilvang FINE 418 Module 7 Group Project Final.docx

Matthew Kvilvang FINE 418 Module 6 Assignment.docx

undergrad_2021_midterm_solutions.docx

Spring 2019 exams and solutions (1).pdf

Practice Problems and Solutions - Topic 11 - REITs.pdf

Module 5 Critical Thinking FIN300-1.doc

_After Tax Financial Planing Example.xlsx

Module 4 Critical Thinking FIN300-1.doc

Related Questions

Use the following information to determine the Prior Year and Current Year trend percents for net sales using the Prior Year as the base year. (Enter the answers in thousands of dollars.) ($ thousands) CurrentYear PriorYear Net sales $ 453,100 $ 230,000 Cost of goods sold 222,019 68,080 Trend Percent for Net Sales: Choose Numerator: / Choose Denominator: / = Trend Percent Current Year: / = % Prior Year: / = %

Compute trend percents for the following accounts using 2015 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.

Use the following information to determine the Prior Year and Current Year trend percents for net sales using the Prior Year a base year. (Enter the answers in thousands of dollars.) Current Prior ($ thousands) Year Year $1,155,080 $431,000 565,989 Net sales Cost of goods sold 127,576 Trend Percent for Net Sales: Choose Numerator: IChoose Denominator: Trend Percent %3D Current Year: %3D Prior Year: % %D

Compute trend percent for the following accounts using 2018 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percent appears to be favorable or unfavorable. 2022 2021 2020 2019 2018 Sales $282,880 $270,800 $252,600 $234,560 $150,000 Cost of goods sold 128,200 122,080 115,280 106,440 67,000 Accounts receivable 18,100 17,300 16,400 15,200 9,000

Computing and analyzing trend percents LO P1 2021 2020 2019 2018 2017 Sales $ 446,122 $ 293,501 $ 242,563 $ 173,880 $ 128,800 Cost of goods sold 221,100 145,365 122,206 87,101 63,112 Accounts receivable 21,592 17,140 16,664 10,137 8,784 Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable.

Compute trend percents for the above accounts, using 2017 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favorable or unfavorable. Sales $ 666,761 $ 432,962 $ 344,990 $ 249,090 $ 180,500 Cost of goods sold 329,263 213,901 172,445 124,054 88,445 Accounts receivable 32,138 25,242 23,632 14,547 12,328

If Year 1 sales equal $830, Year 2 sales equal $913, and Year 3 sales equal $1130, the percentage to be assigned for Year 2 in a trend analysis, assuming that Year 1 is the base year, is 110%. 136%. 91%. 124%. eTextbook and Media

Explains it correctly not use excel

Using data available in the case, calculate the annual growth rate from 2020 to 2021 (in percentages). All calculations should be rounded to two decimals (e.g., 12.77%). > Answer is complete but not entirely correct. 2021 2020 2020-2021 Revenue 2,057,622 1,736,432 18.50 % Cost of Goods Sold 1,259,830 921,980 36.64 % Gross Profit 797,792 814,452 (1.02) % Operating Expenses 789,795 570,245 38.50 % Operating Income 7,997 244,207 2,953.73% Net Income 14,553 191,960 (92.42) %

Compute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. Sales Cost of goods sold Accounts receivable Numerator: 2024 $ 754,236 372,126 36,731 Numerator: 1 2023 $ 499,494 246,502 29,121 Trend Percent for Net Sales: 1 1 1 1 1 1 2024: 2023: 2022: 2021: 2020: Is the trend percent for Net Sales favourable or unfavourable? 2022 $394,857 196,780 27,127 Prev Denominator: Trend Percent for Cost of Goods Sold: 1 Denominator: 5 of 8 2021 $ 265,005 131,752 15,529 = Next > 2020 $ 196,300 96,187 13,407 Trend percent % % % % %

Assume figures were presented for the past 5 years on merchandise sold at Chicago department and discount stores ($ million). Sales in 2022 were $3,154; in 2021, $3,414; in 2020, $3,208; in 2019, $3,152; and in 2018, $3,216. Using 2018 as the base year, complete a trend analysis. (Round your answers to the nearest whole percent.) 2022 2021 2020 2019 2018 Sales $ 3,154 $ 3,414 $ 3,208 $ 3,152 $ 3,216 Sales (in percent) % % % 100 %

Use the following selected information from Corolla to determine the Year 1 and Year 2 trend percentages for net sales using Yeari as the base Year 2. Year Net sales $ 286,200 $ 233,40o0 Cost of goods sold 149,900 131,590 Operating expenses Net earnings 53,240 51,240 30,020 21,820 Multiple Choice 122.6% for Year 2 and 100.0% for Year 1. 35.5% for Year 2 and 38.9% for Year 1. 52.4% for Year 2 and 56.4% for Year 1. 113,9% for Year 2 and 100.0% for Year 1.

1. Angel Trading presents the following sales figures in terms of units. 2014 10 000 2015 11 650 2016 12 395 2017 14 670 2018 18 485 2019 Required: Determine the projected sales on 2019 using either simple moving average or arithmetic geometric curve.

Price earning ratio: market price per common share/ earning per share 3388/ 42.64= 79.46 (Amazon 2020 year) 1847/ 23.46= 78.77 (Amazon 2019 year) 20.24 (Walmart 2020 year) Write financial analysis report.

Assume figures were presented for the past 5 years on merchandise sold at Chicago department and discount stores ($ million). Sales in 2022 were $3,174; in 2021, $3,434; in 2020, $3,188; in 2019, $3,172; and in 2018, $3,236. Using 2018 as the base year, complete a trend analysis. (Round your answers to the nearest whole percent.)

How do I solve these step-by-step?

Selected comparative financial statements of Haroun Company follow. HAROUN COMPANY Comparative Income Statements For Years Ended December 31, 2021-2015 ($ thousands) Sales 2021 Cost of goods sold $ 1,769 1,271 2020 $ 1,549 2019 2018 2017 2016 2015 $ 1,410 $ 1,292 $ 1,206 $ 1,121 $ 919 1,034 889 778 723 676 539 Gross profit 498 515 521 514 483 445 380 Operating expenses Net income 377 295 271 200 173 171 142 $ 121 $ 220 $ 250 $ 314 $ 310 $ 274 $ 238 HAROUN COMPANY Comparative Year-End Balance Sheets December 31, 2021-2015 ($ thousands) Assets Cash Accounts receivable, net Merchandise inventory Other current assets Long-term investments Plant assets, net Total assets Liabilities and Equity 2021 2020 2019 2018 2017 2016 2015 $ 108 773 $ 142 812 $ 148 735 2,797 2,036 1,779 $ 151 564 1,499 $ 157 496 $ 155 $ 160 470 332 1,346 1,144 829 72 65 40 71 60 61 32 e B 220 220 220 220 3,422 3,409 2,982 1,683 $ 7,172 $ 6,464 $ 5,684 $ 4,188 $ 4,019 1,740 1,546 $ 3,596 $ 2,900 1,327 Current liabilities…

Compute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whether the situation as revealed by the trend percents appears to be favourable or unfavourable. 2024 2023 Sales Cost of goods sold Accounts receivable $ 553,119 290,122 26,882 $ 363,894 190,775 21,215 2022 $ 292,284 155,088 20,021 2021 $ 210,276 110,844 12,322 2020 $ 159,300 82,836 10,928 2024: 2023: 2022: 2021: 2020: Numerator: Trend Percent for Net Sales: 1 Is the trend percent for Net Sales favourable or unfavourable? 2024: 2023: 2022: 2021: 2020: Denominator: = Trend percent 0 % 0% 0% 0% 0 % Trend Percent for Cost of Goods Sold: Numerator: Denominator: Is the trend percent for Cost of Goods Sold favourable or unfavourable? = Trend percent 0% 0% 0% 0% 0%

Compute trend percents for the following accounts using 2020 as the base year. For each of the three accounts, state whe situation as revealed by the trend percents appears to be favourable or unfavourable. Sales Cost of goods sold Accounts receivable Numerator: 2024 $ 564,662 296,074 27,273 Numerator: 2024: 2023: 2022: 2021: 2020: Is the trend percent for Net Sales favourable or unfavourable? 2023 $364,298 191,135 21,275 1 1 1 Trend Percent for Net Sales: 1 $ 1 1 2022 293,789 156,170. 20,095 Denominator: Trend Percent for Cost of Goods Sold: Denominator: 2024: 2023: 2022: 2021: 2020: is the trend percent for Cost of Goods Sold favourable or unfavourable? 2021 2020 $ 212,122 $ 158,300 111,503 12,430 = 82,316 10,828 Trend percent Trend percent % de 2 % *** % % % % % % % %

Calculate the Sales Growth of the most recent year. Enter answer as decimal (not percent. Example: .1234 is ok, 12.34% is not ok).

SEE MORE QUESTIONS

Recommended textbooks for you

Essentials Of Investments

Finance

ISBN:9781260013924

Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.

Publisher:Mcgraw-hill Education,

FUNDAMENTALS OF CORPORATE FINANCE

Finance

ISBN:9781260013962

Author:BREALEY

Publisher:RENT MCG

Financial Management: Theory & Practice

Finance

ISBN:9781337909730

Author:Brigham

Publisher:Cengage

Foundations Of Finance

Finance

ISBN:9780134897264

Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William

Publisher:Pearson,

Fundamentals of Financial Management (MindTap Cou...

Finance

ISBN:9781337395250

Author:Eugene F. Brigham, Joel F. Houston

Publisher:Cengage Learning

Corporate Finance (The Mcgraw-hill/Irwin Series i...

Finance

ISBN:9780077861759

Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor

Publisher:McGraw-Hill Education

SEE MORE TEXTBOOKS