1Using and Managing Data and Information BA3020QAAssignment 1 (July cohort 2019-20) Note to students: There are FIVE tasks and you are expected to answer all of them. Answer each task on a separate worksheet of the same Excel file. The deadline for this assignment isMonday21stSeptember2020before 3pm. The submission is via turnitin. Feedback on the students’work is expected within 15 working days of submission.Task 1 (5 marks)Use Excel as a calculator to evaluate the following calculations. For each calculation you should provide the formula you have used.a.61.2 -37.8 x 0.33b.5.48 + 8.8 x 1.9 /√87c.(339–173 / 4) ÷ 48 / √63d.(864 –(143 ÷36)/33) ÷ √3768−121/3x √630−9(61)e.(478–(13)2)105 x ( √1081) Task 2 (5 marks)Use the Excel formatting facilities (show formulae) to answer the following questions:a.Express 7.07% as a fraction in its simplest formb.Express 0.0436 as a percentage (2 decimal places)c.Express 0.688as a fraction in its simplest formd.Tonyscored 48/70in an examination. What percentage did he achieve (1 decimal place)?e.The following table shows sales for a company in the last two years:Year20182019Sales (£000)234188What is the percentage change of sales for the company (2 decimal places)?
2Task 3 (10 marks)Use Excel financial facilities to perform the following scenarios:You need to show the financial formulaeyou have used in each case.a.Calculate the total amount earned in 5years for saving a single amount of £10,000 in a bank account that pays 3.5% per year interest (annual compounding).b.Calculate the annual premiums paid at the end of each year for a 7-year loan of£200,000that costs 2.5% per year.c.Calculate the total amount earned after 5years for regular monthly cash investments of£200 paid into an interest account at the beginning of each month and pays 1.25% interest per year.d.Calculate the monthly repayments (payable at the end of each month) for aperiod of 5-year for a loan of £30,000 costing 4.5%.e.What is the single amount you need to save now (2020) to raise £25,000 by the year 2026if the savingsrate is 3%?Task 4(10 marks)Use an Excel worksheet to setup a table of values and equations for the following scenario:ScenarioYou own a coffeeshop in Holborn. The management cost of the shop is fixed at £6,000 per month. In addition, the owners have calculated that the average cost of coffeeis £1.70. These are assumed to be the only costs.Coffees are sold for an average price of £4.20.Requirement:Estimate the break-even pointby producing a
