Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please include steps on how to do in excel because thats where I have ti put the information Chapter 2 Assignment This assignment is problems
please include steps on how to do in excel because thats where I have ti put the information
Chapter 2 Assignment This assignment is problems 2-10 and 2-22 in the Gips book Each problem MUST be on a separate worksheet! Problem 2-10 At Lou's Discount Furniture Store, Lou, the owner, marks furniture at twice his wholesale cost plus $80. If you bargain with him, he'll drop the price as much as 15%. Create a worksheet that allows you to enter the name and wholesale cost of one piece of furniture and calculates the marked price and the best discount price. Try your worksheet with a Knox Sofa that wholesales for $550 and then for a Cruz Coffee Table that wholesales for $200. Problem 2-22: Kristie has three stocks in her portfolio. Create a worksheet to help her determine how she is doing in the market. The inputs to the worksheet should be the name of each of the three stocks the number of shares of each she purchased, the price per share at which she purchased each stock, and the current price per share of each of the stocks. That is, there should be twelve cells for input. The worksheet should calculate the total amount she spent for each of the stocks, the total current value of each of the stocks, the amount gained or lost for each of her stocks, the percentage gained or lost for each of her stocks, and then the same calculations for the portfolio whole. Also, your worksheet should calculate the percentage of her current portfolio in each of the three stocks. Your worksheet should work automatically for any inputs. as a Step 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