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
All of the following statements regarding the double-entry system are true except:__________. 1. both sides of the accounting eq
Gennadij [26K]

Answer: both sides of the accounting equation must be affected when recording a transaction using the double-entry system

Explanation:

The double entry principle states that for every financial transaction that takes place, there will be an opposite and equal effects in two different accounts at least. It simply implies that there for every transactions that happens, there are two entries which are the credit entry and the debit entry.

In a double entry principle, the addition of all the debits to the accounts must be thesame as the addition of all credits.

Option A which states that both sides of the accounting equation must be affected when recording a transaction using the double-entry system isn't correct. Both side of the accounting equation aren't affected.

6 0
3 years ago
An example of a difficult work decision would be: a. Deciding to finish a task before taking a break b. Deciding to fill the pap
Angelina_Jolie [31]

Answer:

c

Explanation:

8 0
3 years ago
When firms expand into global markets, they are faced with the choice of reducing costs and/or adapting to the local market. Whe
lorasvet [3.4K]
Global strategy & transnational strategy
5 0
3 years ago
Mariano Manufacturing can issue a 25-year, 8.8% annual payment bond at par. Its investment bankers also stated that the company
aivan3 [116]

Answer: 10.13%

Explanation:

The after-tax return on the preferred shares would be:

= After-tax return + Premium required

= (8.8% * (1 - 25%)) + 1%

= 7.6%

For the preferred stock to be issued at par with the above after tax return:

= After tax return / ( 1 - tax)

= 7.6% ( 1 - 25%)

= 10.13%

4 0
3 years ago
Ray is a shareholder of Small Biz Company (SBC). When the directors fail to undertake an action to redress a wrong suffered by S
julsineya [31]

Ray is a shareholder of a small company. When the director falls to undertake an action it falls under derivative suit.

Explanation:

  • Derivative suit is referred to as a law suit that is brought by the shareholder in behalf of the company against the third party.
  • If in a company the employees, the directors as well as the officers are not ready to file a complain against the third party then the shareholder has the right to file a complaint against the third party.
  • Derivative suit is normally filed by the shareholder when there is a mismanagement in the company. To stop the illegal work this action is being taken.  
4 0
3 years ago
Other questions:
  • A property is listed for sale at $235,000. A buyer's offer of $220,000 is rejected by the seller. Six months later, the seller r
    13·1 answer
  • A master production schedule quantity of 300 units will arrive in week 6. Weekly demand over weeks 3 through 10 is forecasted at
    9·1 answer
  • What is the majority of food made from
    7·2 answers
  • A homeowner sued a plumber for damages resulting from the plumber's allegedly faulty installation of water pipes in her basement
    11·1 answer
  • $17,200 is invested, part at 6% and the rest at 2%. If the interest earned from the amount invested at 6% exceeds the interest e
    13·1 answer
  • A sum of $46875 was lent out at simple interest and at the end of 1 year 8 months, the total amount was $50000. Find the rate of
    5·1 answer
  • The portfolio with the lowest standard deviation for any risk premium is called the_______. A.efficient frontier portfolio B.CAL
    10·1 answer
  • Career question #35 easy
    12·1 answer
  • XYZ Company bought real estate properties in Boston 50 years ago for $30,000. In 2020, a real estate appraiser inspects the prop
    14·1 answer
  • One of your associates continues to make the same mistake when stocking shelves you have provided him with this feedback multipl
    12·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!