Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need help trying to fix these 3 excel HW. My teacher is saying it is wrong but I don't know where I went wrong. Problem
Need help trying to fix these 3 excel HW. My teacher is saying it is wrong but I don't know where I went wrong.
Problem 23-12 Three years ago, you founded Outdoor Recreation, Inc., a retailer specializing in the sale of equipment and clothing for recreational activities such as camping, skiing, and hiking. So fa company has gone through three funding rounds: Round Series A Series B Series C Date Feb. 2009 Aug. 2010 Sept. 2011 Investor You Angels Venture Capital Currently, it is 2012 and you need to raise additional capital to expand your business. You h decided to take your firm public through an IPO. You would like to issue an additional 6.5 m new shares through this IPO. Assuming that your firm successfully completes its IPO, you f that 2012 net income will be $7.5 million. a. Your investment banker advises you that the prices of other recent IPOs have been se that the P/E ratios, based on 2012 forecasted earnings, average 20.0. Assuming that y is set at a price that implies a similar multiple, what will your IPO price per share be? b. What percentage of the firm will you own after the IPO? New shares 2012 net income forecast Forward P/E 6,500,000 $7,500,000 20.00 a. Your investment banker advises you that the prices of other recent IPOs have been se that the P/E ratios, based on 2012 forecasted earnings, average 20.0. Assuming that y is set at a price that implies a similar multiple, what will your IPO price per share be? New shares outstanding Earnings per share New price with comparable P/E 3,500,000 $10,000,000 $15.00 b. What percentage of the firm will you own after the IPO? Percentage you own post IPO Requirements 1. 2. 5.00% In cell E21, by using cell references, calculate the number of new shares outstanding In cell E22, by using cell references, calculate the forecasted earnings per share (1 pt 3. In cell E23, by using cell references, calculate the share price for the IPO (1 pt.). 4. In cell E27, by using cell references, calculate the percentage of the firm that you ow the IPO (1 pt.). a retailer specializing in the sale of s camping, skiing, and hiking. So far, your Shares Share Price ($) 500,000 1.00 1,000,000 2.00 2,000,000 3.50 ital to expand your business. You have ould like to issue an additional 6.5 million uccessfully completes its IPO, you forecast s of other recent IPOs have been set such ngs, average 20.0. Assuming that your IPO at will your IPO price per share be? e IPO? s of other recent IPOs have been set such ngs, average 20.0. Assuming that your IPO at will your IPO price per share be? e IPO? number of new shares outstanding (1 pt.). forecasted earnings per share (1 pt.). share price for the IPO (1 pt.). percentage of the firm that you own after Problem 24-12 Boeing Corporation has just issued a callable (at par) three-year, 5% coupon bond with sem annual coupon payments. The bond can be called at par in two years or anytime thereafter o coupon payment date. It has a price of $99. What is the bond's yield to maturity and yield to call? Coupon rate Payment frequency Time until first call date (years) Term of bond (years) Call price Current price Coupon payment Yield to call Yield to maturity Requirements 1. 2. 5.00% Semi-annually 2 3 $100.00 $99.00 $2.50 5.54% 5.37% In cell D13, by using cell references, calculate the semi-annual coupon payment (1 pt To calculate the yield to call of the bond, use the function RATE. In cell D14, by usin function RATE and cell references, calculate the yield to call of the bond (1 pt.). 3. To calculate the yield to maturity of the bond, use the function RATE. In cell D15, by using the function RATE and cell references, calculate the yield to maturity of the bo pt.). oupon bond with semir anytime thereafter on a o maturity and yield to coupon payment (1 pt.). E. In cell D14, by using the f the bond (1 pt.). RATE. In cell D15, by d to maturity of the bond (1 Problem 26-4 The Greek Connection had sales of $32 million in 2009, and a cost of goods sold of $20 mil balance sheet for the firm appears below: THE GREEK CONNECTION Balance Sheet As of December 31, 2009 (000) Assets Cash Accounts receivable Inventory Total current assets $2,000 3,950 1,300 $7,250 Net plant, property and equipment Total Assets $8,500 $15,750 a. Calculate The Greek Connection's net working capital in 2009. b. Calculate the cash conversion cycle of The Greek Connection in 2009. c. The industry average days sales outstanding ratio is 30 days. What would the cash co Greek Connection have been in 2009 had it matched the industry average days sales o Sales (000) Cost of Goods Sold (000) $32,000 $20,000 a. Calculate The Greek Connection's net working capital in 2009. Net working capital (000) $3,530 b. Calculate the cash conversion cycle of The Greek Connection in 2009. Accounts receivable days 45.1 Inventory days Accounts payable days Cash conversion cycle (days) 23.7 27.4 26.3 c. The industry average days sales outstanding ratio is 30 days. What would the cash co Greek Connection have been in 2009 had it matched the industry average days sales o Industry accounts receivable days Cash conversion cycle (days) 30 26.3 Requirements 1. In cell D31, by using cell references, calculate the company's net working capital (1 p 2. To calculate the cash conversion cycle, you need to calculate accounts receivable day days, and accounts payable days. In cell D35, by using cell references, calculate the accounts receivable days(1 pt.). 3. In cell D36, by using cell references, calculate the inventory days (1 pt.). 4. In cell D37, by using cell references, calculate the accounts payable days (1 pt.). 5. In cell D38, by using cell references, calculate the cash conversion cycle (1 pt.). 6. In cell D44, by using cell references, calculate the cash conversion cycle based on the accounts receivable days (1 pt.). nd a cost of goods sold of $20 million. A simplified CONNECTION e Sheet ber 31, 2009 0) Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt Total liabilities Common equity Total liabilities and equity $1,500 1,000 1,220 $3,720 $3,000 $6,720 9,030 $15,750 ital in 2009. Connection in 2009. s 30 days. What would the cash conversion cycle for The d the industry average days sales outstanding? Days in a year ital in 2009. Connection in 2009. 365 s 30 days. What would the cash conversion cycle for The d the industry average days sales outstanding? company's net working capital (1 pt.). calculate accounts receivable days, inventory accounts receivable days(1 pt.). nventory days (1 pt.). accounts payable days (1 pt.). cash conversion cycle (1 pt.). cash conversion cycle based on the industry Problem 23-12 Three years ago, you founded Outdoor Recreation, Inc., a retailer specializing in the sale of equipment and clothing for recreational activities such as camping, skiing, and hiking. So fa company has gone through three funding rounds: Round Series A Series B Series C Date Feb. 2009 Aug. 2010 Sept. 2011 Investor You Angels Venture Capital Currently, it is 2012 and you need to raise additional capital to expand your business. You h decided to take your firm public through an IPO. You would like to issue an additional 6.5 m new shares through this IPO. Assuming that your firm successfully completes its IPO, you f that 2012 net income will be $7.5 million. a. Your investment banker advises you that the prices of other recent IPOs have been se that the P/E ratios, based on 2012 forecasted earnings, average 20.0. Assuming that y is set at a price that implies a similar multiple, what will your IPO price per share be? b. What percentage of the firm will you own after the IPO? New shares 2012 net income forecast Forward P/E 6,500,000 $7,500,000 20.00 a. Your investment banker advises you that the prices of other recent IPOs have been se that the P/E ratios, based on 2012 forecasted earnings, average 20.0. Assuming that y is set at a price that implies a similar multiple, what will your IPO price per share be? New shares outstanding Earnings per share New price with comparable P/E 10,000,000 $0.75 $15.00 b. What percentage of the firm will you own after the IPO? Percentage you own post IPO Requirements 1. 2. 5.00% In cell E21, by using cell references, calculate the number of new shares outstanding In cell E22, by using cell references, calculate the forecasted earnings per share (1 pt 3. In cell E23, by using cell references, calculate the share price for the IPO (1 pt.). 4. In cell E27, by using cell references, calculate the percentage of the firm that you ow the IPO (1 pt.). a retailer specializing in the sale of s camping, skiing, and hiking. So far, your Shares Share Price ($) 500,000 1.00 1,000,000 2.00 2,000,000 3.50 ital to expand your business. You have ould like to issue an additional 6.5 million uccessfully completes its IPO, you forecast s of other recent IPOs have been set such ngs, average 20.0. Assuming that your IPO at will your IPO price per share be? e IPO? s of other recent IPOs have been set such ngs, average 20.0. Assuming that your IPO at will your IPO price per share be? e IPO? number of new shares outstanding (1 pt.). forecasted earnings per share (1 pt.). share price for the IPO (1 pt.). percentage of the firm that you own after Problem 24-12 Boeing Corporation has just issued a callable (at par) three-year, 5% coupon bond with sem annual coupon payments. The bond can be called at par in two years or anytime thereafter o coupon payment date. It has a price of $99. What is the bond's yield to maturity and yield to call? Coupon rate Payment frequency Time until first call date (years) Term of bond (years) Call price Current price Coupon payment Yield to call Yield to maturity Requirements 1. 2. 5.00% Semi-annually 2 3 $100.00 $99.00 $2.50 5.54% 5.37% In cell D13, by using cell references, calculate the semi-annual coupon payment (1 pt To calculate the yield to call of the bond, use the function RATE. In cell D14, by usin function RATE and cell references, calculate the yield to call of the bond (1 pt.). 3. To calculate the yield to maturity of the bond, use the function RATE. In cell D15, by using the function RATE and cell references, calculate the yield to maturity of the bo pt.). oupon bond with semir anytime thereafter on a o maturity and yield to coupon payment (1 pt.). E. In cell D14, by using the f the bond (1 pt.). RATE. In cell D15, by d to maturity of the bond (1 Problem 26-4 The Greek Connection had sales of $32 million in 2009, and a cost of goods sold of $20 mil balance sheet for the firm appears below: THE GREEK CONNECTION Balance Sheet As of December 31, 2009 (000) Assets Cash Accounts receivable Inventory Total current assets $2,000 3,950 1,300 $7,250 Net plant, property and equipment Total Assets $8,500 $15,750 a. Calculate The Greek Connection's net working capital in 2009. b. Calculate the cash conversion cycle of The Greek Connection in 2009. c. The industry average days sales outstanding ratio is 30 days. What would the cash co Greek Connection have been in 2009 had it matched the industry average days sales o Sales (000) Cost of Goods Sold (000) $32,000 $20,000 a. Calculate The Greek Connection's net working capital in 2009. Net working capital (000) $3,530 b. Calculate the cash conversion cycle of The Greek Connection in 2009. Accounts receivable days 45.1 Inventory days Accounts payable days Cash conversion cycle (days) 23.7 27.4 41.4 c. The industry average days sales outstanding ratio is 30 days. What would the cash co Greek Connection have been in 2009 had it matched the industry average days sales o Industry accounts receivable days Cash conversion cycle (days) 30 26.4 Requirements 1. In cell D31, by using cell references, calculate the company's net working capital (1 p 2. To calculate the cash conversion cycle, you need to calculate accounts receivable day days, and accounts payable days. In cell D35, by using cell references, calculate the accounts receivable days(1 pt.). 3. In cell D36, by using cell references, calculate the inventory days (1 pt.). 4. In cell D37, by using cell references, calculate the accounts payable days (1 pt.). 5. In cell D38, by using cell references, calculate the cash conversion cycle (1 pt.). 6. In cell D44, by using cell references, calculate the cash conversion cycle based on the accounts receivable days (1 pt.). nd a cost of goods sold of $20 million. A simplified CONNECTION e Sheet ber 31, 2009 0) Liabilities and Equity Accounts payable Notes payable Accruals Total current liabilities Long-term debt Total liabilities Common equity Total liabilities and equity $1,500 1,000 1,220 $3,720 $3,000 $6,720 9,030 $15,750 ital in 2009. Connection in 2009. s 30 days. What would the cash conversion cycle for The d the industry average days sales outstanding? Days in a year ital in 2009. Connection in 2009. 365 s 30 days. What would the cash conversion cycle for The d the industry average days sales outstanding? company's net working capital (1 pt.). calculate accounts receivable days, inventory accounts receivable days(1 pt.). nventory days (1 pt.). accounts payable days (1 pt.). cash conversion cycle (1 pt.). cash conversion cycle based on the industryStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started