Question: please do on exel . please also show formula B D E G H 1 Assume you just got a home with 6%, 30 years,

please do on exel . please also show formula

B D E G H 1 Assume you just got a home with 6%, 30 years, $300,000, mortgage 2 1. Find out what your monthly mortgage payment is? 3 2. Use solver to find out how much the mortgage amount is if you can only afford to pay $1,200 per month? 4 3. Use goal seek to find out what interest rate is if you can only pay 1,500 per month for this $300,000 mortgage 5 1 6 PV 300,000 7 Rate 6% 8 Year 30 9 Payment 10 11 12 13 14 2. Solver 15 PV 300,000 16 Rate 6% 17 Year 30 18 Payment 19 20 300,000 6% 30 21 3. Goal Seek 22 PV 23 Rate 24 Year 25 Payment 26 27 28

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

PLEASE HELP ME FIGURE OUT THE WORKSHEET. It would be awesome if there was a filled out answer! Transaction Description of transaction June 1: Hudson Bloom invested $190,936.00 cash and computer...

Answer Questions Part A To Pait B $600,000 30-year fixed-rate, constant-payment mortgage that is partially amortizing with a balloon payment of $100,000. The contract interest rate is 3.25% with...

what is it thats missing i will resubmit later . B D E G H Enter your name in this box Tutorial 3 - Present Value of Uneven Cash Flows Find the present value of an uneven cash flow stream invested...

A B D E G H 1 4 2 Please prepare the adjusting entries for the year-end Dec 31, 2020. 3 Assume all the original entries had been recorded in the system. 5 1 On Jani, business bought one equipment for...

Section: Financial Statement Analysis Workbook 6: Cash Flow Statement Sheet: EXCEL Complex Functions RANK Function The ranking functions provides information with respect to a ranking of a...

I need help filling this out and with the questions besides #1 1 Time 2. 3 4 5 6 7 8 9 10 11 12 B SASMX US Equity FKASX US Equity DFFVX US Equity FDVLX US Equity IALAX US Equity 12/31/2010 25.2371...

PLEASE PROVIDE THE FORMULAS I NEED TO USE. PLEASE SPECIFY AND CREATE SIMILAR TABLES. THEY ARE ASKING ME TO PROVIDE THE FORMULAS SO PLEASE PROVIDE THEM. THANKS IN ADVANCE Bond Pricing using Excel's PV...

Can I get help with this, I also need the formulas for the work sheet. AutoSave IF A ExcelAnalytics_QualityCostReport_Template (1) View Tell me Home Insert Draw Page Layout Formulas Data Review Share...

AutoSave or OFF APvc ... Comprehensive Excel Assignment Insert Home - Draw Page Layout Formulas Data Review View Tell me Share Comments X LE Arial v 12 ~ AL A h Wran Text General H H 2 v Pastc B I U...

please help! B D E G H M N Problem 9-32 Complete the steps below using cell references to given data or previous calculations. In some cases, a simple cell reference is all you need. To copy/paste a...

The CVP analysis looks at the break even point with different volume and pricing options and works to determine the most effective. The cost-volume-profit analysis, also commonly known as break-even...

Use the identity of Theoretical Exercise 5 to derive E[X2] when X is an exponential random variable with parameter . Theoretical Exercise 5 Use the result that, for a nonnegative random variable Y,...

In problem 12.6 on page 446, the owner of a moving company wanted to predict labor hours, based on the number of cubic feet moved. The data are stored in Moving . Use the results of that problem. a....

There are many supplier characteristics other than price, such as lead time, reliability, quality, and design capability that impact the total cost of doing business with a supplier. True or False

Think about diversity and inclusion experience at the workplace in your cultural context. Based on your personal experience during the past two years, share one thing that you consider should have...

Understand how relocating headquarters functions from big cities to rural areas influences the work styles and employees work-life balance.

In your view, do you think leadership can influence HRM practices such as recruitment, selection, training, and career development in promoting gender diversity and inclusion in an organization?