{"id":237,"date":"2010-08-04T03:48:24","date_gmt":"2010-08-04T09:48:24","guid":{"rendered":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/?p=237"},"modified":"2010-08-04T03:52:35","modified_gmt":"2010-08-04T09:52:35","slug":"financial-modeling","status":"publish","type":"post","link":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/financial-modeling\/financial-modeling\/","title":{"rendered":"Financial modeling: Modeling time"},"content":{"rendered":"<div id=\"_mcePaste\">Modeling time in excel is quite advanced. The list of features includes<\/div>\n<div id=\"_mcePaste\">\n<ul>\n<li>time<\/li>\n<li>day<\/li>\n<li>hour<\/li>\n<li>minute<\/li>\n<li>second<\/li>\n<li>now<\/li>\n<\/ul>\n<\/div>\n<div id=\"_mcePaste\">You can add or subtract dates, find the number of working days etc. These are however standard commands. It does take some ingenuity to figure out how you can mix and match these to get the output you need when modeling.<\/div>\n<div><\/div>\n<blockquote>\n<div>How can I figure out the number of weekdays between two days in a year?<\/div>\n<\/blockquote>\n<div><\/div>\n<div>\n<div>Recently, we encountered a challenging modeling issue. Output was in seconds and in the time format. Comparing performances and graphing was difficulty. To work around this we converted all the time into seconds using the hour, minute and second feature and then did the analysis using seconds to measure all data points. This simple solutions worked beautifully!<\/div>\n<p>Learn <a title=\"financial modeling techniques\" href=\"http:\/\/www.graduatetutor.com\/financial-modeling-techniques.php\" target=\"_blank\">financial modeling techniques <\/a>with us. \u00a0Our\u00a0<a title=\"financial modeling techniques\" href=\"http:\/\/www.graduatetutor.com\/financial-modeling-techniques.php\" target=\"_blank\">financial modeling tutors <\/a> are MBAs or CPAs and can help you understand the process of laying out your <a title=\"financial modeling\" href=\"http:\/\/www.graduatetutor.com\/financial-modeling-using-Excel.php\" target=\"_blank\">financial model<\/a> step by step\u00a0and help you learn how to build a<a title=\"financial model\" href=\"http:\/\/www.graduatetutor.com\/financial-modeling-using-Excel.php\" target=\"_blank\"> financial model<\/a> from scratch. If you are <a title=\"Writing a business plan\" href=\"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/2009\/12\/writing-business-plans\/\" target=\"_self\">writing a business plan<\/a> or an idea you are evaluating, understand the <a title=\"financial model\" href=\"http:\/\/www.graduatetutor.com\/financial-modeling-using-Excel.php\" target=\"_self\">financial implication<\/a>s by building an <a title=\"Microsoft excel spreadsheet modeling\" href=\"http:\/\/www.graduatetutor.com\/microsoft-excel-tutorial.php\" target=\"_blank\">spreadsheet model<\/a>.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Recently, we encountered a challenging modeling issue. Output was in seconds and in the time format. Comparing performances and graphing was difficulty. To work around this we converted all the time into seconds using the hour, minute and second feature and then did the analysis using seconds to measure all data points. <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[59],"tags":[78,55],"_links":{"self":[{"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/posts\/237"}],"collection":[{"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/comments?post=237"}],"version-history":[{"count":4,"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/posts\/237\/revisions"}],"predecessor-version":[{"id":239,"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/posts\/237\/revisions\/239"}],"wp:attachment":[{"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/media?parent=237"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/categories?post=237"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/graduatetutor.com\/mba-tutor-homework-help\/wp-json\/wp\/v2\/tags?post=237"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}