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
Let's say you graduate from school and you are unemployed or take a low-paying job. What are your debt
elena55 [62]

Answer:

c

Explanation:

7 0
3 years ago
Read 2 more answers
A lot of estimates go into the final calculation to determine market size, and each component needs to be as precise as possible
natulia [17]

True, A  lot of estimates go into the final calculation to determine market size, and each component needs to be as precise as possible. Otherwise, the errors in the estimation get compounded.

What does market size actually mean?

  • The total number of prospective customers for a good or service inside a certain market, along with the potential revenue from those sales, make up the "market size."
  • For a number of reasons, it's critical to determine and comprehend market size.

What is an example of market size?

  • For instance, a shoe company might find 100,000 people who are interested in its product, but data on income and accessibility reveals that only half of them have the resources to make a purchase.
  • The market that is open in that situation has 50,000 potential customers.

Learn more about market size

brainly.com/question/15062891

#SPJ4

3 0
1 year ago
How do we know how much to fix when selling a house?
Sophie [7]
Depending on the location if the house and how much you want to sell it for. Just make sure basic things such as Holes in wall’s are fixed or more noticeable details. Otherwise if the house is in good shape and appliances, heating, water are all fine then not a lot.
5 0
3 years ago
Which of the following represent the newer tools of digital direct​ marketing? A. ​Telemarketing, direct-mail​ marketing, and ca
schepotkina [342]

Answer:

D. Online​ marketing, social media​ marketing, and mobile marketing

Explanation:

Digital direct marketing is a fusion of <em>digital </em>and <em>direct </em>marketing. <em>Digital </em>includes online and mobile (smartphone) media, while the traditional media often refers to telephones, TV, brick-and-mortar shops...

Since the term <em>direct</em> refers to the way of approaching customers, it is important to make a distinction between marketing channels and media that are aimed for a wider public, and the ones that have the possibility of targeting a specific customer or target group.

The only answer that includes types of DDM (digital direct marketing) is <em>D</em>.

Online and social media marketing are tightly related and are digital by nature. They have the functionality to target customers directly with the aid of <em>cookies </em>and data provided by social media. Also, mobile marketing is direct and digital too, as it is related to smartphones and unique phone numbers (thus, it is direct).

5 0
3 years ago
If, at a good's current price, the quantity demanded is 2,000 units and the quantity
8090 [49]

Answer:

C.

Explanation:

Because there is more demand with this good, the current price projects how the sellers are reacting to the market. If there is a shortage of goods being supplied to a market then this means that the sellers price is too high because more people (who arent willing to pay for it for so much) are wanting the product.

8 0
3 years ago
Other questions:
  • Suppose the consumption function is c = $200 + 0.85yd. if disposable income is $400, consumption is
    9·2 answers
  • A fixed cost: Does not change with changes in the volume of activity within the relevant range. Requires the future outlay of ca
    13·1 answer
  • When a transfer is made between cash and cash equivalents with no gain or loss, how is the transaction treated in the statement
    12·2 answers
  • Strickland Company owes $200,000 plus $18,000 of accrued interest to Moran State Bank. The debt is a 10-year, 10% note. During 2
    15·1 answer
  • A researcher submits a study to the IRB that proposes to evaluate a new
    7·1 answer
  • A farmer grows squash in his 100 by 100 foot garden. He then sells the crop at the local farmers' market. Two summers ago, he wa
    9·1 answer
  • Last year you forgot to pay a total of three department store monthly statements. Two of the three charged you a $35 fee for thi
    12·1 answer
  • Explain the governance of internet​
    14·2 answers
  • Carla Vista Company purchases Sandhill Company for $2470000 cash on January 1, 2021. The book value of Sandhill Company’s net as
    15·1 answer
  • 6.
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!