using excel function Solve the following situations (markups based on selling price). Irene Westing bought a...

using excel function

Solve the following situations (markups based on selling price).

Irene Westing bought a desk for $800 from an office supply house. She plans to sell the desk for $1,200. What is Irene’s dollar markup? What is her percent markup on selling price (rounded to the nearest tenth percent)? Check your answer. Selling price will be slightly off due to rounding.
Suki Komar bought dolls for her toy store that cost $14 each. To make her desired profit, Suki must mark up each doll 38% on selling price. What is the selling price of each doll? What is the dollar markup? Check your answer.
Jay Lyman sells calculators. His competitor sells a new calculator line for $16 each. Jay needs a 42% markup on the selling price to make his desired profit, and he must meet price competition. What is Jay’s dollar markup? At what cost can Jay afford to bring these calculators into the store? Check your answer.
Dan Flow sells wrenches for $12 that cost $7. What is Dan’s percent markup on cost? Round to the nearest tenth percent. What is Dan’s percent markup on selling price? Check your answer.

Expert Solution

ekkarill92 answered 1 year ago

11. Assume the current selling price of a firm’s stock is: $100. Using the Excel file...

11. Assume the current selling price of a firm’s stock is: $100. Using the Excel file Dividend Data, compute the firm’s cost of equity using the Gordon dividend model. Dividend Data Quarter Dividend per share 1 0.150 2 0.152 3 0.154 4 0.155 5 0.165 6 0.170 7 0.176 8 0.181 9 0.191 10 0.210 11 0.215 12 0.227 13 0.235 14 0.240 15 0.248 16 0.256 17 0.280 18 0.284 19 0.297 20 0.303 21 0.335 22 0.342 23...

Following are the independent situations. 1. Calculate the selling price for 8% bonds with a par...

Following are the independent situations. 1. Calculate the selling price for 8% bonds with a par value of $567,000 due in 10 years, paying interest on January 1 and July 1 each year, issued at par. 2. Calculate the selling price for bonds with face value of $1,766,000, due in 15 years, paying 7% interest semi-annually, issued at par. 3. Calculate the selling price for bonds with a face value of $781,000 and face rate of 5%, issued to yield...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: (...

(PLEASE READ ) :) Use the data below to solve the following problem using excel: ( I would like to know how do you input the formula for each category, so please explain the process) I will RATE and comment your answer accordingly 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in...

*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...

2. Solve using Microsoft Excel: Use the following data to find the equation of the regression...

2. Solve using Microsoft Excel: Use the following data to find the equation of the regression line. X-Bar 2 4 5 6 Y-Bar 7 11 13 20

Solve using excel: A. Given the following information, calculate the debt coverage ratio of this commercial...

Solve using excel: A. Given the following information, calculate the debt coverage ratio of this commercial loan. Estimated net operating income (NOI) in the first year: $150,000, Debt service in the first year: $100,000, Loan amount: $1,000,000, Purchase price: $1,300,000 B. Given the following information, calculate the loan-to-value ratio of this commercial loan. Estimated net operating income in the first year: $150,000, Debt service in the first year: $100,000, Loan amount: $1,000,000, Purchase price: $1,300,000 C. Given the following information,...

Solve the following questions in excel using the skills from class. Lindner is considering an investment...

Solve the following questions in excel using the skills from class. Lindner is considering an investment with an initial cost of $122,400 and salvage value of 63,600 with the following cash flows over the next 6 years: Year Cash flow 1 $28,750 2 $19,500 3 $44,100 4 $27,900 5 $15,850 6 $13,050 The discount rate is 14.8%. Find the NPV and IRR, what is the decision and what was the criteria for each rule? You want to analyze the impact...

Use the data below to solve the following problem using excel: 1 a) Import the data...

Use the data below to solve the following problem using excel: 1 a) Import the data into an Excel file. Done! b) Create a new column in the spreadsheet to assign the category of each car according to the engine horsepower. For this exercise use IF statements in each cell to determine the class for each vehicle. i. Class 1 if the vehicle horsepower is less than 80 HP. ii. Class 2 if the vehicle horsepower is between 81 and...

Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize...

Solve the following LP problem using the Solver in MS Excel. A farmer wants to customize his fertilizer for his current crop. He can buy plant food mix A and plant food mix B. Each cubic yard of food A contains 20 pounds of phosphoric acid, 30 pounds of nitrogen and 5 pounds of potash. Each cubic yard of food B contains 10 pounds of phosphoric acid, 30 pounds of nitrogen and 10 pounds of potash. He requires a minimum...

Use EXCEL to format this and solve using solve and explain. Biggest problem is once have...

Use EXCEL to format this and solve using solve and explain. Biggest problem is once have variables (which i have half done) is setting up in Excel. A farmer in the Midwst haas 1,000 acres of land on which she intends to plant corn, wheat, and soybeans. Each acre of corn costs $100 for preparation, requires 7 worker-days of labor, and yields a profit of $30. An acre of wheat costs $120 to prepare, requires 10 worker-days, and yields $40...

Question