Automotive Speciality Products PLC (ASP) is a UK company based in the South East of England. ASP has been invited by its largest customer to build a new plant in Central Scotland. Jenny Conrad,...

FINANCIAL MANAGEMENT 1 IT ASSIGNMENT (2010 – 11) THIS WORK SHOULD BE COMPLETED INDIVIDUALLY AND HANDED IN TO RECEPTION (FLOOR 2, ROSE BOWL) BY 12 noon ON WEDNESDAY, 15th DECEMBER 2010. Students should prepare their answers using Excel Spreadsheets, including the use of formulae covered in the Financial Management 1 IT seminar (level 2). Guidelines on the use of these formulae are also included in the Financial Management 1 module on X-stream. ANSWERS SHOULD BE SUBMITTED BOTH ON A COMPACT DISC (CD) AND ON PRINTED PAPER COPIES. EACH SPREADSHEET SHOULD BE FORMATTED AND ALIGNED IN A WAY THAT IS SUITABLE FOR PRESENTATION TO THE BOARD OF DIRECTORS. This assignment represents 40% of the Financial Management 1 module assessment. The remaining 60% will be represented by close book exam in May 2011. Students should note that, in order to pass the FM1 module, they should submit the IT Assignment and also sit the final closed book examination. INTRODUCTION: Performance Boat Products Limited (PBP) is a producer of attachments for boat hulls and motors that help to reduce drag and assist in lifting the boat over the water. This leads to improved speed and power. The attachments can be manufactured as a part for new boats, or fitted to older boats and motors. Customers are usually people who want extra performance from their boats and boat manufacturers offering PBP products as options. BACKGROUND: Dave Edwards sat in the plush boardroom chair, trying to mentally grasp the unorganised flow of information provided by the company’s operational managers. Ultimately, it would be Dave’s responsibility to make financially sound recommendations to the company’s board of directors regarding the three potential investments under consideration. “Are you listening to me, Dave?” It was Mike Whitehead, the marketing division manager. “I have a complete breakdown of our sales projections by region, for each project. I hope you appreciate the time and...