Attached are two chapter that need to be answer in excel. Each answer need to be separate in the excel sheet.

\f16-1 Answer Sales Inventory Turnover ratio (old) Inventory Turnover ratio (new Freed up Cash So, let's find out the freed up cash $10,000,000 2 5 ? We know level of inventory are calculated as follows Inventory = SalesInventory turnover ratio Calculating $ value of old inventory Inventory Old = $10,000.00 Inventory Old = $10,000.00 Calculating $ value of New inventory Inventory = = The freed up cash w= = Cash freed up $100,000,005 $2,000,000 Old Inventory - New Inventory $5,000,000 - $2,000,000 = $3,000,000 If we recall the formula to calculate DSO (Daily Sales Outstanding): DSO = So we have DSO of 17 days and also have average sales i.e $3,500 17 = So Accounts Receivables will be Accounts = 17 X $3,500 Receivables = $59,500 Answer If we recall the formula to calculate DSO (Daily Sales Outstanding): DSO = So we have DSO of 17 days and also have average sales i.e $3,500 17 = So Accounts Receivables will be Accounts = 17 X $3,500 Receivables = $59,500 Nominal cost of Trade formula is: = discount percentage100- Discount Percentage x 365Days credit is Outstanding-Discount Period So putting values in equation: = = = = 397 X 36530-15 0.03093 x 24.33 0.75263 75.26% Effective Cost of Trade Formula is: Periodic rate = 0.03 / 0.97 = 0.3093 Periods/year = 365 / (30-15) = 24.33 EAR = (1 + periodic rate)N - 1 = (1.03093)24.33 - 1 = 109.84% Discount Period Answer Nominal cost = Discount percentage / (100 - DP) * 365 / (Days credit outstanding - Discount period Nominal cost = 1 / 99 * 365 / 60 - 15 Nominal cost = 1 / 99 * 365 / 60 - 15 Nominal cost = 0.010 * 365 / 45 Nominal cost = 0.010 * 8.11 Nominal cost = 8.19% EAR = (1.010)^8.11 - 1 EAR = (1.010)^8.11 - 1 EAR = 1.084922 - 1 EAR = 8.49% ng - Discount period Answer I can calculate Average Accounts Payable as under: = Credit Purchases Per day x Length of Collection Period = = $5,000,000 x 15 Days ### Chapter 17 & 19 Homework 17-1) At today's exchange rate 1 U.S. dollar can be exchange for 9 Mexican pesos or for 111.23 Japanese yen. You have pesos that you would like to exchange for yen. What is the cross rate between the yen and the peso; that is, how many yen would you receive for every peso exchanged? Using the cross-rate like slide 15 of our Chapter 17 PPT, we come up with the following formula: Cross Rate = (Yen/Dollar) x (Dollar/Peso) Yen Dollar Peso 111.23 1 9 Now it's simple algebra: Cross-rate 12.358 yen per peso*** ***The text rounds down our answer so we will do the same with this calculation Answer Once again, we will refer to our Chapter 17 PPT on slide 42 to calculate this answer. Using our example we get the following formula: Forward Rate Spot Rate = 1 + rh 1 + rf rh refers to the periodic interest rate in the home country (in this case the 7% in the US) rf refers to the periodic interest rate in the foreign country (in this case the 5.5% in Japan) No, we have a 6 month time frame so the rates for both the US and Japan must be separated by 2 to speak to this 1/2 year time span. So the 7% yearly rate is really 3.5% for our rh counts (7%/2) also, the 5.5% yearly rate is really 2.75% for our rfcalculations (5.5%/2). The spot-rate is 1 yen compares to $.009 USD. So the computation we have to make sense of is theforward rate asfollows: Forward Rate $0.009 = 1 + 3.5% 1 + 2.75% Forward Rate $0.009 = 1.035 1.0275 Forward Rate $0.009 = 1.007299 Now we perform simple algebra once again by multiplying both sides by $.009 to finalize the forward rate calculation: Forward Rate = $0.00907 Our 6-month forward exchange rate equates to 1 Japanese Yen equallying $.00907 USD wer. Using our be separated by 2 h counts (7%/2) theforward rate asfollows: o finalize the Answer Using the purchasing power parity formula on slide 51 of our Chapter 17 PPT, we find that the Spot rate = Ph/Pf. Ph is the price at "home" or in the US and Pf is the Price at "foreign" or in this case the cost in euros in France. Spot rate = Ph/Pf Ph Pf Spot rate = $500 550 $0.9091 In this case the spot rate equates to 1 euro = $.0901 USD. Now we can invert the formula to find the rate for $1 USD to euros as follows: USD Euro $1 $0.9091 So in conclusion, the spot rate is 1 euro = $.0901 USD. And $1 USD = 1.1000 euros. Answer Dollars should sell for 1/1.50, or 0.6667 euros per dollar