Your friend is currently paying $734 in rent monthly in Fort Wayne and wants to know...

Your friend is currently paying $734 in rent monthly in Fort Wayne and wants to know how much she could borrow using a 30 year mortgage at 4.67% APR using the same payment as her current rent. What could you type into Excel to calculate this value?

Expert Solution

ekkarill92 answered 1 month ago

A family currently live in an apartment whose monthly rent is $1050. They are thinking of...

A family currently live in an apartment whose monthly rent is $1050. They are thinking of buying a house which would cost $250,000. They plan to live in this house for 5 years and sell it at the end of the 5th year. They would put a downpayment of $25,000 and finance the balance through a mortgage at 3% interest rate. The mortgage is to be repaid in 5 annual installments (which include both principal and interest) at the end...

Your friend John has never learned Economics. He wants to know the differences between a change...

Your friend John has never learned Economics. He wants to know the differences between a change in the quantity demanded and a change in demand. He also wants to know the differences between a change in the quantity supplied and a change in supply. a) Explain to John the differences between a change in the quantity demanded and a change in demand. b) Explain to John the differences between a change in the quantity supplied and a change in supply.

Your friend has a stock portfolio that they know nothing about (it was a gift). They know...

Your friend has a stock portfolio that they know nothing about (it was a gift). They know that you have been taking a finance course at GCC and they assume that you are an expert when it comes to financial matters. Your friend is thinking about selling one stock and they have asked for your opinion: If all things remain equal, which stock would you sell and which stock would you definitely keep. There are four stocks in the portfolio: You...

Math of Finance Alex is paying 1184.87 in monthly mortgage payments. She wants to refinance her...

Math of Finance Alex is paying 1184.87 in monthly mortgage payments. She wants to refinance her existing mortgage loan of $100,000 at 14% interest for 30 years that she obtained 4 years ago. Her mortgage officer informed her that he could get her a rate of 10% but the finance cost would include paying a prepayment penalty on the existing loan, which is equal to 6 months interest on the balance of the loan, plus a closing cost of $2000....

Randi wants to know if at least 90% of the employees at her company are currently...

Randi wants to know if at least 90% of the employees at her company are currently enrolled in a health insurance plan. She randomly samples 700 employees and finds that 651 of them are currently enrolled in a plan. Randi conducts a one-proportion hypothesis test at the 5% significance level, to test whether the true proportion of employees enrolled in a plan at this company is greater than 90%. For this test: H0:p=0.9; Ha:p>0.9, which is a right-tailed test. Use...

Dallas Pierce wants to know what rate she is paying on her simple discount note. The...

Dallas Pierce wants to know what rate she is paying on her simple discount note. The maturity value was $8,801 with $81.20 interest for 77 days. What was her rate? (Use 360 days a year. Do not round intermediate calculation. Round your answer to the nearest tenth percent.)

Your friend tells you that she wants to start saving for retirement by investing in the...

Your friend tells you that she wants to start saving for retirement by investing in the stock market. Given that you have taken this finance class, she asks you for advice about what stocks she should buy. What would you tell her?

a) Your friend wants you to explain why it is generally better for taxpayers to “maximize...

a) Your friend wants you to explain why it is generally better for taxpayers to “maximize their after-tax incomes” rather than simply “minimize their current year tax liabilities.” Create a simple example to illustrate how minimizing the current year’s tax liability does not always result in maximizing after-tax income, and walk your friend through each step of your calculation. b) What are the four basic variables that can change the structure of a transaction and impact the related tax consequences?...

Your friend Bob wants to starts an Italian restaurant and you decide to to invest in...

Your friend Bob wants to starts an Italian restaurant and you decide to to invest in it. Bob has full discretion over establishing and managing the business. On January 1, 2010, you gave Bob $150,000 to start the business at the beginning of 2010 in exchange for 10,000 shares and 20,000 common stock, respectively. Bob has agreed to receive a starting salary of $80,000 per year. Bob decided to focus on catering to local corporation, so he rented a space...

C programming My friend Steve wants to buy something nice for himself. He doesn't know want...

*C programming* My friend Steve wants to buy something nice for himself. He doesn't know want he wants yet but he is thinking of spending $1,000 on it or more. He makes $500 a month and has a monthly living expense of $325. He also has a lot of bi-monthly subscription payments which costs him $450 every other month ($450 is the bimonthly expenses) . He wants to know when he will be able to buy want he wants and...

Question