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 installments 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).
Last Completed Projects
topic title | academic level | Writer | delivered |
---|
jQuery(document).ready(function($) { var currentPage = 1; // Initialize current page
function reloadLatestPosts() { // Perform AJAX request $.ajax({ url: lpr_ajax.ajax_url, type: 'post', data: { action: 'lpr_get_latest_posts', paged: currentPage // Send current page number to server }, success: function(response) { // Clear existing content of the container $('#lpr-posts-container').empty();
// Append new posts and fade in $('#lpr-posts-container').append(response).hide().fadeIn('slow');
// Increment current page for next pagination currentPage++; }, error: function(xhr, status, error) { console.error('AJAX request error:', error); } }); }
// Initially load latest posts reloadLatestPosts();
// Example of subsequent reloads setInterval(function() { reloadLatestPosts(); }, 7000); // Reload every 7 seconds });