Calculate the net present value of a purchase.

Calculate the net present value of a purchase.

Completed Project File Name: [your name]-ClemensonImaging-06.xlsx

Skills Covered in This Project
Calculate the net present value of a purchase.
Use TRANSPOSE to rearrange labels into a column.
Concatenate cells to display full names.
Use SUMIFS to summarize data.
Calculate procedure times.
Format times with fractions.
Open the ClemensonImaging-06 workbook and click the Enable Editing button. The file will be renamed automatically to include your name.
Determine the net present value of a new equipment purchase.
Click the Financials sheet tab and select cell H5.
Use NPV with a Rate argument of 4.25%.
Select cells D7:D13 for the Value1 argument and click OK. This is the same as entering each value argument separately.
Edit the formula to add both costs (cells D4 and D5) at the end of the formula. The net present value is $268,921.79.
Use TRANSPOSE and CONCAT to display technician names.
Click the Technicians sheet tab. The names are in rows.
Select cells A4:A10, seven rows in one column.
Select TRANSPOSE from the Lookup & Reference category and select cells A1:G1 for the Array argument.
Press Ctrl+Shift+Enter to complete the array formula.
Repeat the TRANSPOSE task for the first names in cells B4:B10.
Select cell D4 and create a CONCAT formula to display the name in first name, last name order (Figure 6-111).ImagesFigure 6-111 CONCAT formula to display names
Copy the formula in cell D4 to cells D5:D10.
Click the Summary sheet tab, select cell A5, and create a 3D reference to cell D4 on the Technicians sheet.
Copy the formula and preserve the borders.ImagesFigure 6-112 SUMIFS with absolute and relative references
ImagesFigure 6-113 Change time format to display fractions
Use SUMIFS to total number of patients by procedure and technician.
Click the Summary sheet tab and select cell C5.
Use the SUMIFS function with an absolute reference to cells $D$5:$D$41 on the Procedures sheet as the Sum_range argument.
The Criteria_range1 argument is an absolute reference to the image type column on the Procedures sheet, cells $E$5:$E$41.
The Criteria1 argument is a relative reference to cell B5 on the Summary sheet.
The Criteria_range2 argument is an absolute reference to the technician names column on the Procedures sheet.
Select cell A5 for the Criteria2 argument (Figure 6-112).
Copy the formula in cell C5 to cells C6:C11 and preserve the borders.
Use SUMIFS to total number of patients by category and location in cells C14:C15.
Look for and correct format inconsistencies.
Calculate procedure times.
Click the Times sheet tab and select cell F6.
Build a formula to subtract the start time from the end time and multiply those results by 24. The result is shown in hours.
Copy the formula to row 41.
Select cells F6:F41 and open the Format Cells dialog box. On the Number tab, choose Fraction with a Type of Up to two digits (Figure 6-113).
Save and close the workbook (Figure 6-114).
Upload and save your project file.
Submit project for grading.

The post Calculate the net present value of a purchase. appeared first on superioressaypapers.

Using PHP Create A Loan Calculator That Allows For Extra Payments.

Using PHP Create A Loan Calculator That Allows For Extra Payments.

 

Requirements:

-Create a page that allows a user to enter loan information; including Loan Amount, Length of Loan (months or years), Annual Interest Rate (percentage), and Extra Payment Amount.
-Loan Amount is in dollars. This field is required.
-Length of Loan is an integer in months or years. Include a prompt (such as radio buttons or dropdown list) to indicate payment frequency is for months or years. This field is required.
-The loan calculation should adjust appropriately based on months or years selection.
-Annual Interest Rate should be entered as a percentage. This field is required.
-Make sure that all required fields are entered.
-Make sure that all entered fields are valid.
-Display the results of the loan calculation.
-Display the Monthly Payment Amount.
-Display the Total Amount to be paid for the loan (principle and interest).
-Display the Total Interest to be paid for the loan.
-Display an Amortization Schedule for the loan.
-Assume the loan starts on the first day of the following month.
-In the Amortization Schedule show the Payment Number, Payment Date, Payment Amount, Principle Amount, Interest Amount, Extra Payment Amount (if entered), and Loan Balance.
Extra Credit:

-Extra Payment Amount is in dollars and is an additional monthly amount paid towards the principle of the loan. This field is optional.
-If Extra Payment Amount is entered, it must be included in the loan calculation.
-The Extra Payment Amount should be included as part of the monthly payment.
-If Extra Payment Amount is entered, display the Amount of Interest Saved and the Amount of Time Saved.
-Store the values entered in cookies and auto populate fields with previous values from cookies.
Hints:

-Find a formula to calculate the payment amount.
-To use the formula you will need to calculate a few things based on the user input.
-You will need to know the number of monthly payments for the loan. Your formula might call this the length of the loan.
-You will need to know the interest rate per month.
-Now you can start.
-Calculate the number of monthly payments.
-Calculate the interest rate per month.
-Calculate the payment amount.
-You should test this by calculating manually on paper and using a php fiddle to test your code calculations.
-Compare your results to any online mortgage calculator.
-Now use a loop to display each month of the amortization table.
-For each month calculate the balance and the portion of the payment that is principal and interest.
-For the first month, the balance is the same as the loan amount.
-The interest portion of the payment for that month is the balance times the interest rate per month.
-The principal portion of the payment for that month is the payment amount minus the interest portion.
-The balance for that month is the balance from the previous month minus the principal portion of the payment.

The post Using PHP Create A Loan Calculator That Allows For Extra Payments. appeared first on superioressaypapers.

Compare your results to any online mortgage calculator.

Compare your results to any online mortgage calculator.

Requirements:

-Create a page that allows a user to enter loan information; including Loan Amount, Length of Loan (months or years), Annual Interest Rate (percentage), and Extra Payment Amount.
-Loan Amount is in dollars. This field is required.
-Length of Loan is an integer in months or years. Include a prompt (such as radio buttons or dropdown list) to indicate payment frequency is for months or years. This field is required.
-The loan calculation should adjust appropriately based on months or years selection.
-Annual Interest Rate should be entered as a percentage. This field is required.
-Make sure that all required fields are entered.
-Make sure that all entered fields are valid.
-Display the results of the loan calculation.
-Display the Monthly Payment Amount.
-Display the Total Amount to be paid for the loan (principle and interest).
-Display the Total Interest to be paid for the loan.
-Display an Amortization Schedule for the loan.
-Assume the loan starts on the first day of the following month.
-In the Amortization Schedule show the Payment Number, Payment Date, Payment Amount, Principle Amount, Interest Amount, Extra Payment Amount (if entered), and Loan Balance.
Extra Credit:

-Extra Payment Amount is in dollars and is an additional monthly amount paid towards the principle of the loan. This field is optional.
-If Extra Payment Amount is entered, it must be included in the loan calculation.
-The Extra Payment Amount should be included as part of the monthly payment.
-If Extra Payment Amount is entered, display the Amount of Interest Saved and the Amount of Time Saved.
-Store the values entered in cookies and auto populate fields with previous values from cookies.
Hints:

-Find a formula to calculate the payment amount.
-To use the formula you will need to calculate a few things based on the user input.
-You will need to know the number of monthly payments for the loan. Your formula might call this the length of the loan.
-You will need to know the interest rate per month.
-Now you can start.
-Calculate the number of monthly payments.
-Calculate the interest rate per month.
-Calculate the payment amount.
-You should test this by calculating manually on paper and using a php fiddle to test your code calculations.
-Compare your results to any online mortgage calculator.
-Now use a loop to display each month of the amortization table.
-For each month calculate the balance and the portion of the payment that is principal and interest.
-For the first month, the balance is the same as the loan amount.
-The interest portion of the payment for that month is the balance times the interest rate per month.
-The principal portion of the payment for that month is the payment amount minus the interest portion.
-The balance for that month is the balance from the previous month minus the principal portion of the payment.

The post Compare your results to any online mortgage calculator. appeared first on superioressaypapers.

Excel Homework

Excel Homework

Need help with an Excel assignment

The post Excel Homework appeared first on superioressaypapers.

Ethical And Global Environment

Ethical And Global Environment

 

After reviewing the case briefs (attached), answer the questions that follow in 600 words, or as thoroughly as possible.

 

Each case brief has 3 questions

2 case briefs

need plagiarism free

 

2 references

The post Ethical And Global Environment appeared first on superioressaypapers.

reviewing the case briefs (attached), answer the questions that follow in 600 words, or as thoroughly as possible. Each case brief has 3 questions 2 case briefs need plagiarism free 2 references

reviewing the case briefs (attached), answer the questions that follow in 600 words, or as thoroughly as possible.

 

Each case brief has 3 questions

2 case briefs

need plagiarism free

 

2 references

The post reviewing the case briefs (attached), answer the questions that follow in 600 words, or as thoroughly as possible. Each case brief has 3 questions 2 case briefs need plagiarism free 2 references appeared first on superioressaypapers.

Wk4 Apply : Project Plan

Wk4 Apply : Project Plan

Assignment Content
A project plan is based on research and organizational goals.

Use the provided Project Plan template to create a project plan that outlines the operational steps needed to meet each project objective determined in Wk 3 – Apply: Project Metrics.
Use the textbook and other available resources to fill in the appropriate content.
Summarize the justification for your project plan.
Cite all sources following APA guidelines.

The post Wk4 Apply : Project Plan appeared first on superioressaypapers.

Summarize the justification for your project plan.

Summarize the justification for your project plan.

based on research and organizational goals.

Use the provided Project Plan template to create a project plan that outlines the operational steps needed to meet each project objective determined in Wk 3 – Apply: Project Metrics.
Use the textbook and other available resources to fill in the appropriate content.
Summarize the justification for your project plan.
Cite all sources following APA guidelines.

The post Summarize the justification for your project plan. appeared first on superioressaypapers.

Final Project

Final Project

You will find the instructions in the file name “Final Project”

Please keep in mind that I only need the first part of the project.

The post Final Project appeared first on superioressaypapers.