Please answer question number 1.

worksheet chapter 7 Case Problem 4 ROSEY'S ROSES Roscy's Roses has several questions for you that Excel can help answer. Use Roy-13 to solve 3 of these problems. This file has three worksheets aa Present and Future Values, Cost Prediction, and Allowance for Uncol- lete the file answering the questions below and then save the file e13 student name (replacing student name with your name). Print each file sodksheet (Note: This file has three worksheets.) t and Future Values (Calculate the answer and then provide a table for each question. Use the first worksheet of the workbook to answer this 1 Present problem.) How much they would have to pay at the end of each year, assuming a b How much they would have at the end of 4 years if they invested How much they would have to invest today to have $15.000 in d How much they would have at the end of 4 years if they invested 2 percent rate of return, to yield $15,000 at the end of 4 years $1,000 at the end of each year, carning 2 percent per year years, carning 2 percent per year 54,000 today, carning 2 percent per year 2Roscy's Roses is trying to better understand the behavior of their delivery expenses They have accumulated the delivery expenses over the last 24 months and believe that miles driven per month are a good predictor of expense behavior. Use the second worksheet of the workbook to answer this problem a Using the Hi-Lo method, calculate variable cost per mile, fixed costs. and a prediction of delivery expense when they travel 12,000 miles in a month