\$20 Bonus + 25% OFF

# BS1003 Fundamentals Of Finance

0 Download7 Pages / 1,611 Words Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT

## Question:

This coursework tests your basic financial mathematics and statistical modelling skills, using spreadsheet software (Excel – formulae, financial maths, graphical features, Data Analysis and Solver tools) as well as your awareness of the reality of how financial products work. Your answers are to be presented in an essay/report format, for which you will use a word processor. In writing your report, please:

• state and explain all assumptions, on which your answers are based;
• no evidence of use of excel will result in a fail mark for this element of the coursework component of your mark;
• support any answers with the appropriate calculations to arrive at the answer;
• include selected screens of formulae underlying computed values. Failure to demonstrate you have created appropriate formulations on excel will be severelypenalised. Despite the fact that you will be submitting the Excel file as well, your report is a stand-alone document, meaning a reader should not be required to look at the Excel file to understand your analysis, findings and recommendations;

Question 1:

On the 4th of August 2016, the Bank of England (BoE) lowered its main interest rate to 0.25%, the lowest on record since the Bank has published rates in 1970, which still remains unchanged. As a consequence of this low level of rates, Virgin Money’s Lifetime Tracker Standard mortgage rate stands at 3.9%. Jeff Green is about to buy a house in the countryside which costs £650,000 and is taking out a 25-year repayment mortgage for 75% of the acquisition value of the house. Jeff has asked you to assess his ability to pay, in case the BoE increases its interest rate, as his maximum monthly payment cannot exceed £3,200. You are required to:

1. Calculate the monthly payment John will need to meet under current conditions.
2. Assess the effect on John’s monthly payments for each quarter percentage point increase in the BoE rate, up to 4% and identify at which rate Jeff would no longer be able to make the monthly payment.
3. Determine the shortest length (to the nearest month) of mortgage Jeff could take out if he wanted his monthly payment to be exactly the maximum he could afford (based on current mortgage assumptions).

The marketing department has also done some market research and believes demand for each of the models is limited to 2,000 units of the basic model, 1,200 of the medium and 700 of the luxury. You are required to:

1. Formulate this problem as a linear program and use Excel’s Solver to arrive at a solution, identifying what is the maximum profit the company can achieve in the microwave ovens product line.
3. Maximum demand for Premium model was 1,000; OR
4. Maximum available Machining hours were 20,000.
5. Write a report with a recommended production and marketing plan for the company

### Cite This Work

My Assignment Help (2021) Fundamentals Of Finance [Online]. Available from: https://myassignmenthelp.com/free-samples/bs1003-fundamentals-of-finance/pparent-npv-of-the-investment-in-country.html
[Accessed 21 April 2021].

My Assignment Help. 'Fundamentals Of Finance' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/bs1003-fundamentals-of-finance/pparent-npv-of-the-investment-in-country.html> accessed 21 April 2021.

My Assignment Help. Fundamentals Of Finance [Internet]. My Assignment Help. 2021 [cited 21 April 2021]. Available from: https://myassignmenthelp.com/free-samples/bs1003-fundamentals-of-finance/pparent-npv-of-the-investment-in-country.html.

### Latest Management Samples

#### ANAT 1551 Human Anatomy And Physiology

Answer Macular Degeneration Clinical Presentation Macular degeneration (MD) is an eye condition affecting the macula. MD is characterized by loss of central vision, blurred vision, distorted vision, visual hallucination, inability to recognize faces among others.  There are two types of MD wet and dry (Boyd n.p.). Dry MD is characterized by having drusen in macular while wet has new blood vessels that leak their content on macular. The ...

Answer Introduction Ethics and regulations are some major parameter based on which the company should perform there operational activities. Ethical and regulatory norms are to be considered are the major principles which is to be used by an organization when it wants to work in line of assembly working norms to maintain a stagnant principle of working in order of getting organizational objectives. In the current assessment there will be analy...

#### GSP6000 Strategic Management

Answer: Introduction: This study shall consider the Strategic Management and its impact on the performance of Oman Higher education institution. It shall also aim at resolving the problems related to the implementation of the strategic management programs. This study is a mere proposal of the final study that shall be conducted in the latter stage. For the convenience of the assignment, the method and techniques that shall be used for the ana...

#### MNG01222 Facility And Risk Management

Answer: Case history: EL Camino Cantina is an Australian restaurant which is situated at various places in the Australian market. This is a restaurant and bar which is mainly based on the Mexican theme.  The restaurant is located in the cobblestone streets of Sydney. It has very loud, large and fun tex-mex bar which is filled with various cocktails and different wines. The venue has been chosen by the company with great efforts. It is qu...

#### J508 Product And Service Development

Answer: Introduction The essay has been prepared to discuss and argument on the various statements made related to the longer hours of work for employees within the organizations. The first argument states about the impact of longer hours of working on physical health conditions while the remaining statements stated about the increased working hours creating adverse effects of mental health and decline in business productivity too. To provide...

Next

### Save Time & improve Grade

Just share requirement and get customized Solution.

Orders

Overall Rating

Experts

### Our Amazing Features

#### On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

#### Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

#### 24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

#### Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

#### Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

### Our Experts

5/5

234 Order Completed

100% Response Time

### Samantha Ji

#### Singapore, Singapore

5/5

2279 Order Completed

97% Response Time

### Zachary Perez

#### Washington, United States

5/5

230 Order Completed

97% Response Time

### Liya Han

#### Singapore, Singapore

4/5

3076 Order Completed

99% Response Time

### FREE Tools

#### Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

#### Essay Typer

Get different kinds of essays typed in minutes with clicks.

#### Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

#### Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

## Refer Just 5 Friends to Earn More than \$2000

1

1

1

### Live Review

Our Mission Client Satisfaction

Amazing support and great work from the expert! Again thank you guys so much for all the help!

#### User Id: 673036 - 21 Apr 2021

Australia

well prepared project. got some minor editing and got the full marks. will use it again .

#### User Id: 610828 - 21 Apr 2021

Australia

good job and consider the need the of the assignment .good job and consider the need the of the assignment .good job and consider the need the of the assignment .good job and consider the need the of the assignment .good job and consider the need the...

#### User Id: 618488 - 21 Apr 2021

Australia

received 72 marks this is first assignment which i have received above 70 i have given so many assignment after this i received a good marks. but expected is 75 above as i had paid too much money.

Australia

## Order on the go!

Say hello to our new app