AutoSave O off MidTerm Practice ExamAK2020Update - Protected View - P Search Lesauski, Justin U File Home Insert Page Layout Formulas Data Review View Help Finess Data A Share P Comments O PROTECTED VIEW Be careful-files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View. Enable Editing fr No B12 c D E F G H K M R 1 To correctly complete the tasks on this worksheet, do NOT use raw numbers or values in formulas. 2 3 1. Enter a function in the first yellow cell to determine the amount of Sales Tax. 4 2. Copy the formula down the Sales Tax column to calculate Sales Tax, if any, for the other transactions. 5 3. Use the subtotal outline view to total the sales tax for exempt and non exempt transactions 7 8 5% <-- Sales Tax Rate Yes Таx Exempt Not Tax Exempt 9 0% <--Exempt Rate No 10 11 ransaction Tax Exempt (Yes/No) Price Sales Tax Total Due $ 52.60 $ 2.63 $ 55.23 $ 24.00 $ 1.20 $ 25.20 12 2 No 13 4 No 14 No Total $ 3.83 $ 19.95 $ $ 19.95 $ 231.88 15 Yes 16 3 Yes $231.88 $ 17 Yes Total 18 Grand Total $ 3.83 19 20 21 22 23 24 25

Q: How to draw a npv profile in excel

A: Net Present Value (NPV) is the technique used to discount the cash flows generated over the period…

Q: For the second question, were you able to show how that problem would be worked out?

A: The par value is stated in the corporate charter and the company cannot issue shares below the par…

Q: What is the project’s PI?

A: The PI index the profitability index of the project. The shows the profitability of the project…

Q: What does CAPM allow you to calculate?

A: CAPM model is basically the capital asset pricing model which helps us in determining the expected…

Q: Is there a way to set this up in Excel, please?

A: Face Value  $       1,000.00 Time Period (Years) 10 Price of Bond  $         311.05

Q: Distinguish between reverse engineering and reengineering.

A:

Q: Give an example of each.

A: Cost standard example: The estimation to regulate the entire direct material cost standard and…

Q: how do you calculate this question with excel formulas

A: Information Provided: Withdraw amount = $10,000 Interest rate = 6% Years for withdraw $10,000 = 5…

Q: Explain about the Black–Scholes model.

A: Black Scholes option pricing model is probably the most commonly used option pricing model in…

Q: What is Monte Carlo simulation analysis?

A: Answer: Monte Carlo simulation is the methodology used to consider the financial, cost, and project…

Q: What would be the equasion for solving this

A: Formula for calculating yearly payment: Yearly payment=(Loan amount * Rate%)1-1(1+Rate%)n

Q: what is the formula break down

A: When you are taking the warranty than you must see that buying the warranty is worth or not and if…

Q: Explain the benefits of JIT.

A: Just-in-time manufacturing system: Just-in-time (JIT) manufacturing system is an approach to…

Q: can you show formulas used to solve this problem?

A: The concept of the time value of money determines that the worth of money gets depreciated over a…

Q: you!

A: The original question deals with preparation of amortisation schedule.

Q: Write out the equation for the CML and explain its meaning.

A: After the investment in different securities, portfolio is prepared which describe the overall…

Q: how to learn CAPM model?

A: In order to increase the return and reduce the risk, investors generally adding some securities to…