1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
BartSMP [9]
3 years ago
12

Add a new field named LoanPayment using the Expression Builder. Insert the Pmt function to determine the monthly payment for a 2

-year loan, paid monthly, with a 5% yearly interest rate. The present value is 25000 minus the savings balance. For example, if the purchase price were 25000, with 5000 in savings to put toward the purchase, your present value would be 20000. Ensure the number displays as a positive number.

Business
1 answer:
pogonyaev3 years ago
7 0

Solution and Explanation:

Step 1:  Start Access. Open the downloaded Access file named exploring_a03_Grader_a1.accdb.

Step 2:  Assume that there is a table Loans with the following attributes as shown in the screenshot.

Step 3:  Create a query using Query Design. From the Clients table, display the client’s FirstName and LastName. From the Accounts table, select the Savings Balance and OpenDate. Sort the query by savings balance in descending order.

   Add a calculated field named AccountTime that calculates the number of days each client’s accounts have been open. Assume today’s date is 12/31/2017. Recall dates must be enclosed in # to denote to Access it is a date. Format the results in General Number format. Save the query as Account Longevity, and close the query.

Step 4: Create a query using Query Design. From the Clients table, display the client first name and last name. From the Accounts table, select the savings balance.

   Add appropriate grouping, so the client’s total retirement account savings balances are displayed. Add a sort so the highest total savings balances are displayed first.

Step 5:  Switch to Datasheet view. Add a totals row displaying the count of the last name and the average of total savings balances. Save the query as Total Balances By Client and close the query.

Step 6:  Create a copy of the Total Balances By Client query. Name the query Total Balances By State. Open the query in Design view and remove the client name from the query. Add grouping by the client’s state.

   Sort by the client’s state in Ascending order and remove the sort on the savings balance. Add criteria so clients with retirement account savings balances of $10,000 or more are factored in to the query. Save and close the query.

Step 7:   Create a new query using Query Design. From the Clients table, select the client first name, last name, and state. From the Accounts table, select the Savings Balance. Add criteria so only customers with balances under $15,000 are displayed.

Step 8:  Enter the sample data (one record) as shown in the screenshot.

As present value is given as 25000, loan amount is taken as 25000.

As savings balance is given as 5000, savings balance is taken as 5000.

Step 9: SS

Step 10:  Then an expression builder is opened as shown in the screenshot:

Step 11:  Then enter the expression pmt(0.5/12, 2*12, - (Loan Amount] – [Savings balance]), 0, 0) as shown in the screenshot.

You might be interested in
Winona and Hubert need to decide which one of them will take time off from work to complete the rather urgent task of shearing t
Flauer [41]

Answer: Winona has the lowest opportunity cost of completing the task.

Explanation:

Based on the information given in the question, the opportunity cost will be calculated as:

= Earnings per hour × Hours taken to complete the task

Therefore, for Winona, the opportunity cost will be:

= 1 × $200.

= $200.

For Hubert, the opportunity cost will be:

= 9 × $25

= $225

Therefore, based on the calculation above, Winona has the lowest opportunity cost of completing the task.

5 0
2 years ago
You are a delivery manager introducing a new product from your unit to the market. What steps should you take to mitigate any IP
schepotkina [342]

Answer:

Explanation:

There are various steps that you should take to make sure that your product does not violate any IPs. First, you should make sure that those involved with the product sign an NDA. This document prevents these individuals from talking about the product with others, which prevents it's details from leaking and allowing competitors to beat you to market by releasing their own version of your product first. The other step that you should take would be to patent the design and trademark the name of the product. Doing so will make sure that the product is unique and that it does not interfere with already existant IP's, as well as preventing others from infringing on your product.

3 0
2 years ago
Fred and Lucy are married, ages 33 and 32, and together have AGI of $120,000 in 2019. They have four dependents and file a joint
algol13

Answer:

$3,800

Explanation:

According to the scenario, computation of the given data are as follow:-

Particular                                                              Amount ($)

Bills of doctor and dentist and hospital expenses 9,200

Less-received an insurance reimbursement 4,400

Add-prescribed medicines and drugs 3,000

Add-high deductible health insurance policy 5,000

Total expenses                                  12,800

Less- AGI’s 7.5%   ($120,000 × 7.5% ) $9,000

After Deduction medical expenses for 2019 $3,800

Contribution of $2,600 to a qualification health savings account is a deduction for AGI. So it is not calculated in deduction.  

According to the analysis, option (C) $3,800 is correct.

3 0
2 years ago
The most substantive part of a formal report is the body; thus, you’ll want to compose the body with care to effectively convey
mihalych1998 [28]

Answer:

Make $200,000 in less than two month (Send me a message if interested)

If I told you that you could turn your spare time into a side-income online business, would you be interested?    

I recently became introduced to two guys that were able to make $960,824.41 within 31 days. These guys are “anti-gurus”... they’re everyday guys. Their students have generated millions, too.   And they also helped me to make over $200,000 in less than 2 months

I was able to convince them to show you how they did it on a free training event this week.

They’re sharing this for the first time and will show you how to turn your spare time into a $100,000.00 online side business.  

The best part? You can do this with NO experience / technical skills.

Explanation:

5 0
3 years ago
What is the major determinant of supply? 
Lorico [155]
The available demand and goods
4 0
3 years ago
Other questions:
  • What is a saturated market like for sellers? A. Consumer demand is higher. B. It contains more available consumers. C. It is mor
    9·2 answers
  • Vhat expenses do you need to budget for if you choose to rent a home? Check all that apply.
    13·2 answers
  • Why do economists study the money supply? Be sure to mention liquidity in your response.
    6·2 answers
  • Charles Edgar Duryea and his brother are credited with creating which of the following products?
    9·2 answers
  • A(n) 11.0​%, ​25-year bond has a par value of​ $1,000 and a call price of ​$1 comma 025. ​(The bond's first call date is in 5​ y
    7·1 answer
  • If you find yourself part of a team at work , what is the best way to behave during a team meeting ?
    6·2 answers
  • Association Rule Analysis is the statistical technique typically used to conduct market basket analysis.
    5·1 answer
  • Reconciliation of pretax accounting income and taxable income: Pretax accounting income $ 179,000 Permanent differences (16,100
    13·1 answer
  • Builder's risk coverage is typically procured by the owner, with protection extended to the contractor and subcontractors. Quest
    15·1 answer
  • Bina Co. purchased a vehicle on January 1st for $15,000 and estimates it will use the vehicle for eight years with a $3,000 salv
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!