Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Connect 2-semester For Auditing & Assurance Services A Systematic Approach

Authors: Author

10th Edition

1259292045, 9781259292040

More Books

Students also viewed these Accounting questions

Question

What is a production operation?

Answered: 1 week ago

Question

How do you add two harmonic motions having different frequencies?

Answered: 1 week ago

Question

What are their resources?

Answered: 1 week ago