Answer number 1 - Calculate the following ratios for Pebblebrook (round all amounts to one decimal place).

Answer number 1 -
 

Transcribed Image Text:

Calculate the following ratios for Pebblebrook (round all amounts to one decimal place). Show your work in the space provided, including the amounts you used in the formula (both the numerator and denominator). To complete this work, you will need to access the three years 10-Ks (current year posted on Canvas). A table has been provided below for the required format you should present your work. Net Income (loss)/Total Revenue (Net Sales) Net profit margin 2023 -74,276/1,419,949 = -0.05230892095, -5.2% AVERAGE TOTAL ASSETS: Net Sales/Average Total Assets (5.824,973+6,133,540)/2 Asset turnover NET INCOME/AVERAGE TOTAL ASSETS Return on assets =5,979,256.5 1,419,949/5,979,256.5 =0.2374791916 -> 0.24 -74,276/5,979,256.5 =-0.01242228026, -1.2% 2022 -84981/1,391,891 = -0.0610543498, -6.1% 6,133,540+ 6,261,190/2 = 6,197,365 1,391,891/6,197,365= 0.2245940008-> 0.22 -84981/6,197,365 = -1.4% 2021 -186,372/733,044 = -0.254243, -25.4% 2020 -392,593/442,888 = -0.8864385578 -> -88.6% 6,261,190+6,076,366/2 = 6,168,778 6,076,366 +6,498,555 6,287,460.5 442,888/6,287,460.5 = 0.07 733,044/6,168,778 = 0.12 -186372/6,168,778 = -0.0302121425 -> -3.0% 2019 115,725/ 1,612,213 7.8% 6,498,555 +6,978,348/2= 6,738,451.5 1,612,213/6,738,451.5 -0.24 -392,593/6,287,460.5 = -6.2% 115,725/6,738,451.5 = 0.01717382695-> 1.7% OPERATING INCOME/TOTAL REVENUES (NET SALES) 37,810/ 1,419,949 = 0.02662771691, 2.7% 14,722/1,391,891 = 0.01057697765, 1.1% (292,709)/442,888=-66.1% (89,791)/733,044 = -12.2% Operating profit margin 229,342/1,612,213 -> 14.2% 1. Discuss the significant trends you see in the operating results during this period. Be specific and discuss the trend for each ratio (1 page singled-spaced written summary). Calculate the following ratios for Pebblebrook (round all amounts to one decimal place). Show your work in the space provided, including the amounts you used in the formula (both the numerator and denominator). To complete this work, you will need to access the three years 10-Ks (current year posted on Canvas). A table has been provided below for the required format you should present your work. Net Income (loss)/Total Revenue (Net Sales) Net profit margin 2023 -74,276/1,419,949 = -0.05230892095, -5.2% AVERAGE TOTAL ASSETS: Net Sales/Average Total Assets (5.824,973+6,133,540)/2 Asset turnover NET INCOME/AVERAGE TOTAL ASSETS Return on assets =5,979,256.5 1,419,949/5,979,256.5 =0.2374791916 -> 0.24 -74,276/5,979,256.5 =-0.01242228026, -1.2% 2022 -84981/1,391,891 = -0.0610543498, -6.1% 6,133,540+ 6,261,190/2 = 6,197,365 1,391,891/6,197,365= 0.2245940008-> 0.22 -84981/6,197,365 = -1.4% 2021 -186,372/733,044 = -0.254243, -25.4% 2020 -392,593/442,888 = -0.8864385578 -> -88.6% 6,261,190+6,076,366/2 = 6,168,778 6,076,366 +6,498,555 6,287,460.5 442,888/6,287,460.5 = 0.07 733,044/6,168,778 = 0.12 -186372/6,168,778 = -0.0302121425 -> -3.0% 2019 115,725/ 1,612,213 7.8% 6,498,555 +6,978,348/2= 6,738,451.5 1,612,213/6,738,451.5 -0.24 -392,593/6,287,460.5 = -6.2% 115,725/6,738,451.5 = 0.01717382695-> 1.7% OPERATING INCOME/TOTAL REVENUES (NET SALES) 37,810/ 1,419,949 = 0.02662771691, 2.7% 14,722/1,391,891 = 0.01057697765, 1.1% (292,709)/442,888=-66.1% (89,791)/733,044 = -12.2% Operating profit margin 229,342/1,612,213 -> 14.2% 1. Discuss the significant trends you see in the operating results during this period. Be specific and discuss the trend for each ratio (1 page singled-spaced written summary).