BrushEm sells toothpaste and has to decide whether to raise prices starting in 2021. It evaluated how much Extra Revenue will be generated by the new price of $2.50($/tube) versus the current price of $2.00. Its Market Share (in units) decreases with a price increase per a linear model: Market Share = 1.0-0.1*Price. The expected 2020 Market Size for toothpaste is 100 million (M) tubes and is expected to grow 5.0M tubes per year. Below is the spreadsheet BrushEm used to estimate the Extra Revenue a. What Excel formulas were put into cells B14 and B19 to compute Market Shares with the Current and the New Price, respectively?
B14: = B19: =
b. What formula was put into cell C15 in order to do a Fill Right to calculate Sales with the Current Price from 2020 to 2023?
C15: =
c. What formula was put into cell C21 to do a Fill Right to calculate Revenue with the New Price from 2021 to 2023?
C21: =
d. What formula was put into cell C24 to compute the Extra Revenue in 2021 as the difference between Revenue with the New Price minus the Revenue with the Current Price?
C24: =

Belstone, inc. is a merchandiser of stone ornaments. it sold 15,000 units during the year. the company has provided the following information: sales revenue $ 520,000 purchases (excluding freight in) 338,500 selling and administrative expenses 32,000 freight in 15,000 beginning merchandise inventory 43,000 ending merchandise inventory 58,500 how much is the gross profit for the year?

In a macroeconomic context, what are implicit liabilities? money owed to people possessing government issued bonds. the amount of money that firms collectively owe to shareholders. money that the government has promised to pay in the future. payments that the federal government undertakes only during periods of recession. which of the choices is a significant implicit liability in the united states? military spending education spending national science foundation spending social security

This problem has been solved! see the answercompute and interpret altman's z-scoresfollowing is selected financial information for ebay, for its fiscal years 2005 and 2006.(in millions, except per share data) 2006 2005current assets $ 4,970.59 $ 3,183.24current liabilities 2,518.39 1,484.93total assets 13,494.01 11,788.99total liabilities 2,589.38 1,741.00shares outstanding 1,368.51 1,404.18retained earnings 4,538.35 2,819.64stock price per share 30.07 43.22sales 5,969.74 4,552.40earnings before interest and taxes 1,439.77 1,445.18compute and interpret altman z-scores for the company for both years. (do not round until your final answer; then round your answers to two decimal places.)2006 z-score = answer2005 z-score = answerwhich of the following best describes the company's likelihood to go bankrupt given the z-score in 2006 compared to 2007.the z-score in 2006 is half of the 2005 score. both z-scores are well above the score that represents a healthy company.the z-score in 2006 is double the 2005 score. the z-score has increased sharply, which suggests the company has greatly increased the risk of bankruptcy.the z-score in 2006 is half of the 2005 score. the z-score has decreased sharply, which suggests the company is in financial distress.the z-score in 2006 is double the 2005 score. the z-score has increased sharply, which suggests the company has greatly lowered the risk of bankruptcy.