BUAD 3050 Task 5

BUAD 3050 Task 5 - the solutions in excel (office 2003 file...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
BUAD 3050 Information Technology Management Individual Homework Assignment #5 Read Plug-in T4 and solve the LoanAnalysis (Problem 5, Budget Constraints) and SpotlightVideo problems . You are expected to read and practice and understand the materials in plug-in T3 well in advance. Based on the materials learnt you should be in a position to solve the above mentioned two problems. The solution in excel should be built with correct formulas wherever calculations are required. Typing in numbers without using formulas are not accepted and you will get ‘0’ points. You are also expected to provide recommendations in executive summary format within the spreadsheet or as a separate document. You are expected to justify your recommendation form the analyzed numbers. In order to complete the assignment, post one file containing, two tabs,
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: the solutions in excel (office 2003 file format) and name the tabs as LoanAnalysis and SpotlightVideo. Name the file your name HW5 For Loan analysis paste the goal seek function you had used so that I will know you had used the function and not typed the data. Goal seek is available under Data-what if analysis. Your Excel sheet should have the following at the bottom of the solution table:- Your full name- Full course number and section (e.g. BUAD 3050)- Assignment number I would like to remind you that all homework assignments must be done and submitted individually. Grading scale: Loan Analysis 15 pts. (max) SpotlightVideo 15 pts. (max)-------30 pts. (max) Feel free to e-mail me if you have any questions....
View Full Document

This note was uploaded on 06/05/2011 for the course BUAD 3050 taught by Professor Moni during the Spring '10 term at Toledo.

Ask a homework question - tutors are online