You are ready to buy a house and you have $85,000 for a down payment and closing costs. Closing costs are estimated to be 3.5% of the loan value. You have an annual salary of $125,000. The bank is willing to allow your monthly mortgage payment to be equal to 28% of your monthly income. The interest rate on the loan is 4.5% per year with monthly compounding for a 30-year fixed rate loan. How much money will the bank loan you? How much can you offer for the house? Construct a loan amortization table for the mortgage. Please submit the actual Excel spreadsheet with formulas embedded in the spreadsheet.

You are ready to buy a house and you have $85,000 for a down payment and closing costs. Closing costs are estimated to be 3.5% of the loan value.   You have an annual salary of $125,000. The bank is willing to allow your monthly mortgage payment to be equal to 28% of your monthly income.   The interest rate on the loan is 4.5% per year with monthly compounding for a 30-year fixed rate loan.

1. How much money will the bank loan you?
2. How much can you offer for the house?
3. Construct a loan amortization table for the mortgage. Please submit the actual Excel spreadsheet with formulas embedded in the spreadsheet.

For this activity, you will use a top-down approach to create part of a specification for development of a video game. The game can be any genre or theme that you’d like, but for this exercise, you should choose a single platform (smartphones, iPads, PS4, PC, etc.).

Your “roadmap” should cover the following elements:

Cover the specifications for the software needs and requirements of the project, presented in a top-down approach (starting with the “big picture” and breaking down from there into the smaller requirements). Remember that not all software needs are programming related. For each need or requirement, propose a software solution. You don’t have to specify the exact program you would use (for example, you could say “word processor” instead of “Microsoft Word”).
You may use any requirement tracking technique or tool you like in building the requirements list. One program, platform, application, or piece of software can meet many different needs.
In a separate section, you should describe how you will apply prototyping techniques and analysis tools to improve the final product. Again, this discussion should consider what, if any, tools you will need to implement prototyping.
You can structure the specification however you think best, as long as it maintains a top-down perspective. Suggested formats include a flowchart style or a tiered outline.
You can refer to online resources or independent research for this activity.

A. A sphere and a cylinder roll down an inclined plane, started from rest at the same time. They have the same radii, but not the same mass. Does one reach the bottom first? If so, which? Explain your reasoning.

B. Two spheres roll down an inclined plane, starting from rest at the same time. Sphere A has radius R and mass m. Sphere 2 has radius 2R and mass m. Does one reach the bottom first? If so, which? Explain your reasoning.

The price of a home is $200,000. The bank requires a 15% down payment. The buyer is offered two mortgage options: 15-year fixed at 8% or 30-year fixed at 8%. Calculate the amount of interest paid for each option. How much does the buyer save in interest with the 15-year option?

find the monthly payment for the 15-year option

find the monthly payment for the 30-year

Calculate the total cost of interest for both mortgage options. How much does the buyer save in interest with the 15-year option?

Bob is driving down the street. He is not very attentive and crashes into the car in front of him, driven by Fred, a licensed blaster. Unknown to Bob, the car has dynamite in the trunk and explodes. The Fred is killed instantly. Jane is a pedestrian on the sidewalk next to the explosion. She is struck by flying chunks of the exploding car and seriously injured. The blast is so severe, that windows shatter as far a five blocks away. Ted is struck by falling glass from an office building five blocks from the explosion. Bob is uninjured. He is sued by Jane, Ted, and Fred's estate. How would he defend himself against these actions? Would his defenses likely be successful in any of the cases? Why or why not?

A dye molecule has electrons that are free to travel up and down a chain of atoms, giving electron energy states that are given by the particle-in-a-box model, with En=(0.34eV)n2. What are the three longest wavelengths of visible light that the molecule will absorb?

The following data (read the data down first and then over to the right) represent the weekly accounts receivable balance (in $1000) of a hardware distributor over a 30-week period.

1. Set up a (individuals) control chart on the accounts balance and a moving range chart (i.e. calculate the appropriate centerline and control limits). Plot the charts and supplement the individuals control chart with supplementary runs rules (i.e. apply the Western Electric runs rules for detecting non-random patterns on control charts). Note: Use the X-Y chart in Excel to plot the control charts.
2. Were there any out-of-control points identified in part (a)? If so, assume a special-cause explanation can be given to the associated point(s).
3. From the result of part (b), what are the appropriate prospective/trial limits for the charts?

Ms. Tweeter is buying a house with a cost of $350,000. She will make a down payment of $20,000 on the house, and the rest will be paid for with a mortgage loan. Her mortgage loan has an APR of 4.9% compounded semi-annually, with a weekly payment schedule and a time horizon of 20 years. The first payment is due in one week's time. How much principal have you paid off after 5 years?

Python

What are the advantages and disadvantages of solving a problem that can be broken down into repetitive tasks with recursion as opposed to a loop? Explain your answer.

Sometimes Graphical User Interfaces can be too cluttered. What is a good general rule of thumb for the number of elements on a page within a Graphical User Interface? Explain your answer.