Question

In: Finance

*****PLEASE SHOW IN EXCEL***** 4. An industrial grade lazer printer with the retail price is offered...

*****PLEASE SHOW IN EXCEL*****

4. An industrial grade lazer printer with the retail price is offered for $3,900. If the sale is for 36 months with $135 per monthly payments, what is the interest rate?
A. 14.15 percent
B. 14.90 percent
C. 15.60 percent
D. 18.75 percent
E. 19.15 percent

Solutions

Expert Solution


Related Solutions

Please use excel and demonstrate the formulae used. A medium-sized industrial grade compressor can be purchased...
Please use excel and demonstrate the formulae used. A medium-sized industrial grade compressor can be purchased for $35,000. Annual O&M costs are expected to increase $1,300 every year, with a 1st year O&M cost of $2,000. (MARR = 16%, and planning horizon is 10 years) The compressor salvage value for a given period t, is calculated based on the following equation: Salvage value (t) = $30,000– $3,000 * t a) Find the Optimum Replacement Interval for this Equipment b) Find...
SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score...
SHOW STEPS IN EXCEL PLEASE Consider the following data on price ($) and the overall score for six stereo headphones tested by a certain magazine. The overall score is based on sound quality and effectiveness of ambient noise reduction. Scores range from 0 (lowest) to 100 (highest). Brand Price ($) Score A 180 76 B 150 71 C 95 61 D 70 58 E 70 40 F 35 24 (a) The estimated regression equation for this data is ŷ =...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a...
PLEASE SHOW ALL WORK IN EXCEL!!!!!!! SHOW CALCULATIONS / FORMULAS IN EXCEL!!!!!!!! Voters arrive at a polling station at an average of 4 per minute (Poisson) where the service rate is 50 per hour (Poisson). a. What is the average number of voters in the system with 5 voter booths? (10 pts) b. What is the minimum number of voting booths needed to keep the average time in the system under three minutes? (10 pts) PLEASE SHOW ALL WORK IN...
PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and...
PLEASE USE AN EXCEL CHART AND SHOW THE FUNCTIONS USED! THANK YOU! XYZ stock price and dividend history are as follows: Year Beginning-of-Year Price Dividend Paid at Year-End 2015 $ 106 $ 5 2016 101 5 2017 89 5 2018 94 5 An investor buys three shares of XYZ at the beginning of 2015, buys another two shares at the beginning of 2016, sells one share at the beginning of 2017, and sells all four remaining shares at the beginning...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering...
*****SOLVE USING EXCEL AND PLEASE SHOW THE EXCEL COMMANDS THAT ARE USED******** A company is considering the purchase of a new machine that will enable it to increase its expected sales. The machine will have a price of $100,000.  In addition, the machine must be installed and tested.  The costs of installation and testing will amount to $10,000.  The machine will be depreciated using 3-years MACRS. (Use MACRS table from class excel exercise by copying the table and pasting it)          The equipment will...
Questions 1-4 show excel formulas The coupon rate and market price for the 10-year US Treasury...
Questions 1-4 show excel formulas The coupon rate and market price for the 10-year US Treasury bond are 2.50% and 96.3828 respectively. Note, the price is expressed as a percentage of par (like other bonds). If par is $1000, then this bond is selling for $963.828. 1. Assume that this bond will mature in precisely 10 years, pay coupons semi-annually, and has a par value of $1000. Determine the yield to maturity for this bond. 2. Compute the duration of...
Please show excel farmulas Homework One    Line 18 Lower price for cup to 1.40 Homework Two...
Please show excel farmulas Homework One    Line 18 Lower price for cup to 1.40 Homework Two Line 34    Higher Fixed but lower Variable Conrads Coffee (Page 266 Chapter 13) Class Example F+G E/A Chg in E B-E C-I Quantity Total Rev ($1.50 a cup) Marginal Revenue Total cost Fixed Cost Var Cost Avg Total costs Marginal costs Profit MR-MC $    3.00     3.00 $ (3.00) 1 $     1.50      1.50 $    3.30     3.00        0.30         3.30        0.30...
***Excel is required to solve this problem. Please use excel and show all formulas used in...
***Excel is required to solve this problem. Please use excel and show all formulas used in each cell I would really appreciate the work*** Three-Stage FCFE Model: Biomet Inc., designs, manufactures and markets reconstructive and trauma devices, and reported earnings per share of $0.56 in 1993, on which it paid no dividends. (It had revenues per share in 1993 of $2.91). It had capital expenditures of $0.13 per share in 1993 and depreciation in the same year of $0.08 per...
Please answer in excel only. How do I create the graphs in excel and show the...
Please answer in excel only. How do I create the graphs in excel and show the data. Discuss the following two cost functions: TC=20+4Q TC=20+2Q+0.5Q^2 a) Calculate all cost curves and plot these curves on graphs. Total Cost Total Fixed Cost Total Variable Cost Average Total Cost Average Fixed Cost Average Variable Cost Marginal Cost b) In each case, indicate the point at which diminishing returns occur. (For question a), compute the required costs and plot the curves for quantities...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The...
PLEASE COMPUTE THE FOLLOWING IN EXCEL and show the excel sheet, Thank you so much! The following are the runs scored totals for 9 players for the 2016 New York Yankees: 56,43,63,68,58,80,71,32,19 (a) Find the mean and median (b) Find the standard deviation of this population (c) Considering this as a normal sample of American League players for the 2016 season, find a 99% Confidence Interval for the actual mean of Runs Scored for AL players, 2016 . (d) Considering...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT