answer.
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
wlad13 [49]
2 years ago
11

Ann would like to buy a house. It costs $2,500,000. Her down payment will be $50,000. She will take out a mortgage for the remai

nder. It will be a 30 year, fully amortizing, FRM, with constant monthly payments and monthly compounding. The annual interest rate is 4.00%. She will pay $5,000 in closing costs at origination. She will also pay 1.75% of the balance in buy-down points at origination. Note: the home is bought and the loan is taken in month 0, the first payment is due in month
1. In the spreadsheet where it says "cash inflow", "outflow" and "net cash flow" you should only take into account cash flow related to the mortgage.
2. Fill in the spreadsheet (sheet "FA AMORTIZATION SCHEDULE") for Ann. (It is called an amortization schedule or amortization calendar.)
3. Compute Ann's annualized IRR for the mortgage in the spreadsheet. (Use the net cash flow.)
(3.a) What is the annualized IRR for the mortgage?
(3.b) Is it higher or lower than the mortgage contract rate?
(3.c) Why? in excel
Business
1 answer:
Ne4ueva [31]2 years ago
7 0

Answer:

Please find the cash flow calculation in the excel attached

Explanation:

The Equated Monthly Installment (Monthly payment is calculated based on the fact that there is a balloon payment at the end of the term.

3b)IRR is lower than the

mortgage contract rate

3c) The reason for lower IRR is the inclusion of Balloon Payment

Please find the cash flow calculation:-

Download xlsx
You might be interested in
Brinker accepts all major bank credit cards, including First Savings Bank's, which assesses a 2.5% charge on sales for using its
omeli [17]

Answer:

Explanation:

The journal entry is shown below:

Cash A/c Dr $4,680

Credit card expenses A/c Dr $120     ($4,800 × 2.5%)

        To Sales $4,800

(Being the deposit is recorded and the remaining balance is debited to the cash account)

We debited the cash and the credit card expenses account and credited the sales account so that proper entry would be recorded.

6 0
2 years ago
One of the growers is excited by this advancement because now she can sell more crops, which she believes will increase revenue
larisa [96]
<span>In order to understand if the innovation will bring about more sales in terms of elasticity of the products, it is necessary to analyze the impact that a price drop would have on the demand for the produce being sold, and to what extent a price decrease will proportionally increase demand.</span>
7 0
2 years ago
Exercise 8-3
7nadin3 [17]

Answer:

(a) Prepare the entries to record sales and collections during the period.

  • It had net credit sales of $800,000  

Dr Accounts receivable $ 800,000

Cr Sales $ 800,000

  • Collections of $763,000.

Dr CASH $ 763,000

Cr Accounts receivable $ 763,000

(b) Prepare the entry to record the write-off of uncollectible accounts during the period.

  • It wrote off as uncollectible accounts receivable of $7,300  

Dr Allowance for Uncollectible Accounts $ 7,300

Cr Accounts receivable $ 7,300

(c) Prepare the entries to record the recovery of the uncollectible account during the period.

  • However, a $3,100 account previously written off as uncollectible was recovered before the end of the current period.  

Dr Accounts receivable $ 3,100

Cr Allowance for Uncollectible Accounts $ 3,100

(d) Prepare the entry to record bad debt expense for the period.

  • Uncollectible accounts are estimated to total $25,000 at the end of the period.  

Dr Bad Debt Expense $ 20,200

Cr Allowance for Uncollectible Accounts $ 20,200

Explanation:

If the company applies the allowance method, it means that the account Allowance for Uncollectible Accounts must show as balance the estimated value of $25,000

Because the company already has a CREDIT balance in the Allowance for Doubtful Accounts it's necessary to register an entry that complement the existing value and reflect the estimated value, $ 20,200  

Bad accounts are those credits granted by the company and there is no possibility of being charged.

When customers buy products on credits but the company cannot collect the debt, then it's necessary to cancel the unpaid invoice as uncollectible.

One way is to directly cancel bad debts at the time it was decided that the credit is bad, the total amount reported as bad debt expenses negatively affect the income statement and the accounts receivable are reduced by the same amount, less assets

The other way is to determine a percentage of the total amount of accounts receivable as bad debts, there are many ways to analyze accounts receivable and calculate the value of bad debts.

When the company has the percentage of uncollectible accounts, the required journal entry is Bad Expenses (debit) with Reserve for Bad Accounts (credit)

At the time of cancellation, since the expenses were recognized before, we only use the Allowance for Uncollectible Accounts (Debit)  with accounts receivable (credit), with this we are recognizing the bad credit of the company.

7 0
2 years ago
Cheapo Manufacturing decided to lease a 100,000 square foot facility. What type of lease will they most likely sign? A net lease
Alinara [238K]

Net lease type will be the most likely sign by Cheapo manufacturing.

<u>Explanation:</u>

Single net leases, which are frequently alluded to as a Net or N rent, are not as regular in the rental world. In a rent this way, the proprietor moves a negligible measure of hazard to the occupant, who covers the property charges. This implies some other cost, for example, protection, support and fixes, and utilities—are the proprietor's obligation. The landowner is likewise liable for any support and additionally fixes that must be finished over the span of the rent inside the property.  

Occupants under a solitary net rent wind up paying marginally lower lease than with a standard rent as a result of the additional expense of property charges. In any case, a higher rental installment doesn't reduce the landowner's obligation regarding staying up with the latest.

6 0
2 years ago
Merchants Credit Union has decided that tellers must rotate through a new weekend shift on Saturday afternoons because several o
HACTEHA [7]

Answer:

Innovative change

Explanation:

Innovation means change, hopefully a change for better. When a company decides to innovate its processes it means that it is trying to improve existing processes to make them more effective and more productive. In this particular case by starting to work weekend shifts they are trying to offer a better service.

8 0
2 years ago
Other questions:
  • Three critical activities occur during group socialization that affect the productivity of teams, and they are:
    10·1 answer
  • Grannyâs Restaurant sells apple pies. Granny knows that the demand curve for her pies does not shift over time, but she wants to
    15·1 answer
  • Consider two cities, City A and City B, which are entirely identical except that Uber operates in City A, but not in City B. Con
    14·1 answer
  • Arthur is 10 years old. Tuition for one year at a public two-year college is $3,125. In 8 years, tuition is expected to increase
    7·2 answers
  • A worksheet contains sales dollars for agents with your company. The values are $1,250, $1,090, $985, $985, $880, $756, $675, $6
    7·1 answer
  • Suppose that a chicken farm uses a nearby stream to dispose of the wastes released by its chickens. These wastes flow downstream
    7·1 answer
  • Bonita Industries used high-low data from June and July to determine its variable cost of $12 per unit. Additional information f
    10·1 answer
  • The Foundational 15 [LO10-1, LO10-2, LO10-3]
    10·1 answer
  • What does the region between the lines to the left of the​ break-even point​ represent? A. The number of riding mowers that must
    13·1 answer
  • Julie Brown is a single woman in her late 20s. She is renting an apartment in the fashionable part of town for $1,000 a month. A
    10·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!