Set up a worksheet with all the relevant numbers

Assignment Help Operation Management
Reference no: EM132951105

For this assignment, you are to turn in an Excel workbook containing three sheets: 1 worksheet and 2 chart sheets. Please label the sheets as specified below. Make sure the charts have a good format. In particular, pay attention to labels and titles for the axes.

Joe is making a plan for paying off his credit card debt. He has a balance of $30,000. He is being charged an annual interest rate of 8%. He will not make any new charges on this card and wants to reduce his debt to $0 within 2 years by making a fixed monthly payment. He has arranged to make the payments due at the end of the month starting in June 2021.

-Set up a worksheet with all the relevant numbers above.
-On the same worksheet, create a table that shows, for each month: the date of -payment, the number of the payment, the total payment, interest payment, principal payment, and remaining balance for the two-year period. You can fill in the dates using Fill/Series. Take advantage of autofill for the formulas. Rename the worksheet as "Payment Table".
-Show the net present value of all monthly payments.
-Be sure every number is well-formatted and well-labeled.
-make a line chart on a separate sheet that shows the remaining balance as it
-changes over time. The labels on the horizontal axis should be dates.
-Hint: You may want to do it the following way: Select the Remaining Balance column and then insert your chart. Then use Chart Tools/Design/Data/Select Data and edit the horizontal axis to be labelled by the Date column. Be sure the vertical axis starts at 0. Rename the worksheet as "Remaining Balance Chart".
-Create astacked column chart on another sheet that shows interest payment and principal payment for each month. Be sure to change the horizontal axis labels to show the dates. Rename the worksheet as "Payment Chart"

Reference no: EM132951105

Questions Cloud

What is the structure of the market : What is the structure of the market and does the business have pricing power? Is there sufficient product differentiation among the competitors?
What the anticipated cash inflow for the month of march is : What the anticipated cash inflow for the month of March is? The company's past experience indicates that 70% of the accounts receivable are collected
Are you increasing or decreasing net present value breakeven : When you spend more upfront (at the acquisition stage). Are you increasing or decreasing the net present value breakeven point?
Describe what is a schedule management plan : You realize you will also need a Schedule Management Plan. Describe what is a Schedule Management Plan and state why it is necessary to have such a plan.
Set up a worksheet with all the relevant numbers : For this assignment, you are to turn in an Excel workbook containing three sheets: 1 worksheet and 2 chart sheets. Please label the sheets as specified below. M
Compute the equivalent cost per unit : Compute the equivalent cost per unit. Compete the equivalent cost per unit assuming the ending inventory is considered to be 60 percent complete.
Describe the errors and delays associated across : Explain in detail the concept of economics of logistics and describe the errors and delays associated across the boundaries of logistics processes
How many rooms must be sold to breakeven : What day of the month does it break even if it averages a paid occupancy percentage of 60%? Assume all 100 rooms are available for sale each day.
What is covid healthcare system of japan : What is COVID healthcare system of Japan? Provide the internal strength of it?

Reviews

Write a Review

Operation Management Questions & Answers

  Very important and volatile resource in our economy

The price of oil is a very important and volatile resource in our economy.

  Manufacturer approaches customer

A manufacturer approaches a customer and asks which of the 237 dimensions on the blueprint are critical.

  Performing service-learning in the community

What are three areas you would improve before performing service-learning in the community?

  Evaluate the firms rationale for it outsourcing

If a firm has a divisional structure and places extreme pressures on its divisional executives to meet short-term profitability goals?

  Something they like doing reduces their intrinsic motivation

Explain why paying someone to do something they like doing reduces their intrinsic motivation?

  Difference between patents in US v Europe

You can discuss a great patent war, stolen patent case, difference between patents in US v Europe, etc.

  All have experienced serious color issues within cultures

Lighter-toned Hispanics, East Asians, and Asians, among others, all have experienced serious color issues within their cultures.

  What is likely their primary tactic

Is there someone in your world that is difficult to negotiate with? What is likely their primary tactic? How can you best respond to it?

  Describe the elements and the goals of the promotional mix

Describe the elements and the goals of the Promotional mix.

  Employees have less loyalty to an organization

“In today’s economy, employees have less loyalty to an organization and are quite willing to move to another organization to advance their careers.”

  Still relevant in the current business environment

Do you belive it is still relevant in the current business environment? Why or Why not? Use at least two real life examples to support your argument.

  Draw the aon project network by using microsoft project

for an organization the following project schedule is given. assume that all times are in days.taskpredecessornormal

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd