Complete assignment 1 parts a, b, and c and assignment 2 parts a, b, and c at th

Complete assignment 1 parts a, b, and c and assignment 2 parts a, b, and c at the end of chapter 5 on pages 129-130. Each part a, b, and c should be on different worksheets. When you are working on part c be sure to save part an as a separate worksheet so that part a is not replaced by c. No need to print, just upload the file.
Chapter 5 Assignments
1 Create a new What SUP Loan Amortization ScheduleUsing the ch5-03 file to start your work, create a worksheet (similar to the one created in this chapter) that calculates the required annual payment for an $850,000, 7-year loan at 5 percent and includes a loan amortization schedule. (Be sure to use names in the worksheet, as illustrated in the chapter. You will also need to format the cells.) Save your file asch5-03_student_name (replacing student_name with your name).
A. Print the newly completed worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer.
B. Use the Scenario Manager to create a scenario using rates of 10, 9,7, and 6 percent to calculate alternative payments. Print the resulting summary worksheet.
C. Use Excel’s goal seek feature to calculate the amount the company could borrow if it could afford a payment of $120,000 per year assuming the original loan assumptions. Print the resulting worksheet in Valueview, with your name and date printed in the lower left footer and the file name in the lower right footer.
2 Create a new What SUP Bond Amortization ScheduleUsing the ch5-04 file to start your work, create a worksheet (similar to the one created in this chapter) that calculates the bond proceeds for a $2,500,000,10-year, 4 percent stated interest bond issued when the market interest rate is 5 percent. Include a bond amortization schedule and use names in the worksheet, as illustrated in the chapter (You will also need to format the cells.) Save your file as ch5-04_student_name (replacing student_name with your name).
A. Print the newly completed worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer.
B. Use the Scenario Manager to create a scenario using stated rates of3, 3.5, 4.5, and 6 percent to calculate alternative annual interest payments and bond proceeds. Print the resulting summary worksheet.
C. Use Excel’s goal seek feature to calculate the stated interest rate it would have to pay under the original bond analysis (in part a) to achieve bond proceeds of $2,600,000. Print the resulting worksheet in Value view, with your name and date printed in the lower left footer and the file name in the lower right footer.

*I need the question completed using excel and shown with calculations using exc

*I need the question completed using excel and shown with calculations using excel. Also, I need a 1-2 page brief written report that summarizes the case study and excel sheet. I added an example of a brief written report for you to go off of.*
Case Study #2 uses the same data file as Case Study #1. It is intended to test your knowledge of how to run and interpret tests of joint significance, tests of individual Significance, and interval estimates. You will also be asked to check for violations of OLS assumptions.
A realty brokerage firm is interested in creating a model for predicting the selling price for homes located in a suburban area in central Virginia. The head of the firm believes there are several variables that are potential predictors of housing prices, including living area (square feet), number of bedrooms, and number of bathrooms. The information in the MBA 7715 Case Study No. 1 Data.xlsx file pertains to a random sample of houses in the particular geographic areas of interest.
Using the data file and the simple and multiple regression models run from Case Study #1, interpret the test of joint and individual significance. Use the technique described in the textbook to run confidence and prediction intervals. Run a test of linear restrictions to determine whether the influence of number of bedrooms differs from the influence of number of bathrooms. Finally, check for violations of model assumptions.
You will be required to prepare and submit a brief written report (Microsoft Word format) that summarizes the case study background, your analysis methodology, your analysis findings, and your recommendations (refer to the sample regression report for further guidance).
You will also be required to submit a single Excel spreadsheet for the case study that clearly shows all calculations or other work you performed to derive the necessary regression statistics to derive your findings and recommendations. The regression statistics for each regression model associated with the case study must be presented on a separate worksheet within the spreadsheet. No credit will be granted for any portions of your analyses for which the necessary statistics have not been derived using Excel, or for which you have not shown all calculations or other work performed to derive the statistics or other values associated with your reported findings and recommendations.
Your Excel spreadsheet and Word file must be submitted via the submission link provided in Canvas. This assignment must be completed without the assistance of others; all work submitted must be your own original work. You may refer to the course text, course materials posted on Canvas, and your personal notes in connection with completing the case study. You will only be allowed one attempt for completing the case study. Please pay careful attention to the expectations outlined in the case study grading rubric.
Finally, submit the Instructions/Answer sheet with your answers to the listed questions and references to the item numbers in your Excel workbook.
Note: Include your models that you ran in Case Study #1 in your submission. Or, in case you ran the models incorrectly in Case Study #1, re-run the models correctly and include them in your submission.

APA Format, References, Assignment Tips: Start by expanding the basic WBS from t

APA Format, References, Assignment
Tips: Start by expanding the basic WBS from the Charter that you completed in IP2 to include all of the tasks necessary to complete the renovation, equipping, supplying, training, and marketing of this new location. Think about how you could decompose your work packages into activities and subactivities to complete this coffee house project. You should use all of the project artifacts (deliverables) you produced so far and the given project scenario to identify all of the activities that are needed.
You should be able to come up with 30–50 activities, both major and sub-activities, for your schedule baseline. Once those activities have been identified, next refine your schedule by plugging in start and finish dates, durations, and predecessor relationships. Your project name must go in the first row, and all other activates should be indented under it. You should link all activities to summary tasks and subactivities to the main activity. You may make assumptions for any of this work. You should save the finished project file as: “Week 3 deliverable_your name.” Use the Week 2 IP templet information to do week 3 IP templet and make sure you do a closing at the end.

WEEK 4 DISCUSSION WELCOME to the discussion for WEEK 4. Please respond in comple

WEEK 4 DISCUSSION
WELCOME to the discussion for WEEK 4. Please respond in complete sentences for each question, unless directed to do otherwise, demonstrating in your reply that you have read the material in order to receive full credit. Please note that participating in this discussion counts toward your class participation grade.
DISCUSSION
This week, we will discuss Week 4’s reading assignments. We will be discussing some of the ways we can analyze data in Excel. The ability to analyze data is a powerful skill that helps you make better decisions. Microsoft Excel is one of the top tools for data analysis.
TOPICS
This week’s Read and Watch covers the following topics:
Analyze data instantly
Using Goal Seek
What-iI-Analysis
Scenarios
Data Tables
Using Solver
Scenario Manager Wizard
Create a relationship between imported data
Scenario Summary Report
Import data from a database
Import data using copy and paste
Cleaning Data with Flash Fill
Import Wizard
Appending Worksheets from one workbook.
Loading Data Using Power Query
Adding Automatic Subtotals
Filtering Records
Delimiter
Scenario Manager
Two-Variable What -If Table
YOUR RESPONSE
1. Item A: From the list of topics above, choose one topic or term discussed in the reading that stood out to you.
2. Item B: Define or describe the topic, including citations from the Read & Watch material or any other source.
3. Item C: Discuss the importance of the topic. Cite specific examples from the reading. Include personal experience with the topic if appropriate.
4. There are THREE items to each response: Item A (topic), Item B (definition and citation), Item C (discussion) unless specified otherwise. When you respond, they should be labeled accordingly.
Minimum Topic Response: PLEASE RESPOND IN THREE OR MORE SENTENCES PER TOPIC.
NOTE 1: Please make sure you answer EACH item and LABEL each item (#1, #2, #3, etc) so that I can easily check that each item has been answered.
NOTE 2: Please do not attach a file to the conference–enter your reply into the text area provided.
NOTE 3: After you post your response, please review it to make sure it is formatted correctly and is easy to read.