Order now
     

Discuss about Visual basic maximum 10 pages, and need to write a report around 2500 words

Section A Individual Assignment (maximum 10 pages, around 2500 words report)

1 (i) Create and document a model to produce an amortization table for a fixed rate loan using the PMT function. The loan is to be repaid in equal annual instalments over its life and the first payment is to be made at the end of the first year. Use dialog boxes to get the user inputs. The program should validate the user input for reasonableness and ask the user to modify any input that is not appropriate. For output, use the worksheet predesigned with labels, table headings, formatting and so on. (40 Marks)

(ii) Explain and demonstrate another alternative VBA method which you could have used to solve the problem in No (i) instead of using the PMT function in VBA. (40 marks)

(iii) Use the above VBA exercise in (a) and (b) to compare and contrast VBA modelling and Excel modelling (20 marks)
(Total 100 marks).
———-
Added on 12.04.2016 08:15
please do the section A individual assignment only.

Place a similar order with us or any form of academic custom essays related subject and it will be delivered within its deadline. All assignments are written from scratch based on the instructions which you will provide to ensure it is original and not plagiarized. Kindly use the calculator below to get your order cost; Do not hesitate to contact our support staff if you need any clarifications.

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page:
 Total:

Whatever level of paper you need – college, university, research paper, term paper or just a high school paper, you can safely place an order.