$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

BS1003 Fundamentals Of Finance

tag 0 Download7 Pages / 1,611 Words tag 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;
  • clearly indicate your answer/recommendations;
  • 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.
  2. How would your answer change if the following happened:
  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
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 7 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

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.


If you are looking for online proofreading services, then MyAssignmenthelp.com is your best bet. Being one of the leading providers of editing and proofreading solutions, MyAssignmenthelp.com is dedicated to evaluating our assignment papers thoroughly. Our team of expert proofreaders knows how to weed out minute grammatical mistakes in the copy and rectify the same with precision. Apart from that, we are into customised paper writing service. Ask us to “write my paper” if you wish to get the entire project composed and revised by our in-house writers. So, what are you waiting for? Consult us right away.

Latest Management Samples

ANAT 1551 Human Anatomy And Physiology

Download : 0 | Pages : 4

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 ...

Read More arrow

PHI205 Business Ethics

Download : 0 | Pages : 4

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...

Read More arrow

GSP6000 Strategic Management

Download : 0 | Pages : 9

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...

Read More arrow

MNG01222 Facility And Risk Management

Download : 0 | Pages : 3

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...

Read More arrow

J508 Product And Service Development

Download : 0 | Pages : 8

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...

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,657,348

Orders

4.9/5

Overall Rating

5,122

Experts

Our Amazing Features

delivery

On Time Delivery

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

work

Plagiarism Free Work

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

time

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.

subject

Services For All Subjects

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

price

Best Price Guarantee

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

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

234 Order Completed

100% Response Time

Samantha Ji

PhD in Chemistry with Specialization in Organic

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

2279 Order Completed

97% Response Time

Zachary Perez

PhD in Computer Science and Information System

Washington, United States

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

230 Order Completed

97% Response Time

Liya Han

Master Of Science in Geotechnical Engineering (MSc Geotec)

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 4/5

3076 Order Completed

99% Response Time

Emily Wei

Doctor of Philosophy (Ph.D) in Civil Engineering

Singapore, Singapore

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

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

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

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

calculator

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

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

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

flag

User Id: 673036 - 21 Apr 2021

Australia

student rating student rating student rating student rating student rating

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

flag

User Id: 610828 - 21 Apr 2021

Australia

student rating student rating student rating student rating student rating

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...

flag

User Id: 618488 - 21 Apr 2021

Australia

student rating student rating student rating student rating student rating

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.

flag

User Id: 431633 - 21 Apr 2021

Australia

student rating student rating student rating student rating student rating

Order on the go!

Say hello to our new app

callback request mobile
Have any Query?